Log In
Register
Home
March 10, 2016
Offline
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
July 16, 2010
Offline
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
1 Guest(s)
