Forum Discussion
Solved
Sorting rows in a pivot table by date columns
I'm trying to sort a pivot table which has company names in rows and closing month in columns.
On Windows that's easier, you may add data to data model and sort in it Deal Name by Close Date. Afraid that doesn't work on Mac.
As variant you may add helper column to source table as
=TEXT([@[Close Date]],"00000")&[@[Deal Name]]add it to PivotTable into rows on first position, that will be like
Now we may narrow or hide that column, with grouping dates by month and year result will be
HelloJoe_IG
By default, when you prepare PivotTable Report, the data is alphabetize (Sort A to Z) as seen below
If you want to sort it to suit your need, click on the drop-down icon in cell A3 (company) and choose Sort Z to A as seen in the caption below
