Forum Discussion
Pivot Table Filter for Months in Chronological Order
I have my raw data filtered chronologically by months of the year. When I create a pivot table, the months show out of chronological order. How do I get the pivot table filter drop down to display mo...
Renumber the months as follows to solve your problem:
01-January
02-February
03-March
04-April
05-May
06-June
07-July
etc. and require a two-digit month identifier. This will keep your dates in the correct order for what you are attempting to do.