I have a request for a bar chart or a pivot table on a dashboard that will show This Years Order Count vs Last Years Order Count by month for a specific customer.
I have a Generic Inquiry that Pulls the Customer Name, the Posting Period and the Order Number for last year and this year.
When I create a bar chart or a pivot table the data is show sequentially January 2023, February 2023, March 2023…….. December 2023, January 2024, February 2024….. etc.
Is there a way to either have a bar chart or pivot table where January 2023 and January 2024 would be side by side, followed by February 2023 and February 2024 and so on.
Thank you
