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 months in chronological order?
Thank you in advance!
7 Replies
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.
SaraOC Most likely the dates aren't real dates but texts that look like dates. Then they get sorted in alphabetical order. "10-O" thus get sorted before "1-J".
SaraOC But then they are still texts. What do you see when you enter a formula like =ISNUMBER(A1) where A1 would be a cell with a date?
