Forum Discussion
Solved
Pivot Tables by Month an Year
I have created a PivotTable to analyse Orders, Items Sold, Sales, Fees, New Sales by Month and Date. It works well from the start on 26 May 2020 to 31 Dec 2020and listed months in order and can be ex...
HansVogelaar Thank you for this, it worked. So simple when you know how. I spent many hours not getting there.
Right-click any of the dates/months in the pivot table.
Select Group... from the context menu.
I assume that the check box for Months is ticked.
Tick the check box for Years as well, then click OK.
HansVogelaar Thank you for this, it worked. So simple when you know how. I spent many hours not getting there.