Forum

Notifications
Clear all

Sort order of months in Pivot Report

2 Posts
2 Users
0 Reactions
80 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

In the Pivot report, I enter an order date for rows - and group for months -
The problem is that the months are presented to me in the order of ABC and not in the order of the months in January-February
Then when I make a monthly cumulative amount, he fails.
How to sort the months in a report automatically by their order of the year -
January, February ...?
Thanks for the response!!
Leah

 
Posted : 19/05/2020 5:07 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Leah,

You haven't said whether your Pivot report is a regular PivotTable or Power Pivot and I don't know if these dates are grouped using the right-click date in PivotTable > Group tool, or you have added a column to your source data that contains the month label. However, I suspect it's the latter and this is recognised as text, hence the alphabetical sorting.

If you want months to be treated as months in a regular PivotTable, you should use the PivotTable grouping, not a column you add to your source data.

If you're using Power Pivot you can add a column to your source data and then use the 'Sort By' setting to sort the month names by a numeric month number column.

Mynda

 
Posted : 19/05/2020 8:03 pm
Share: