Dec 16 2021 09:26 AM
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!
Dec 16 2021 10:44 AM
@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".
Dec 16 2021 10:54 AM
Dec 16 2021 11:19 AM
@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?
Dec 17 2021 06:55 AM
Dec 17 2021 06:57 AM
@SaraOC That is odd indeed!
Dec 18 2021 06:40 AM
Perhaps you may share how source data looks like mentioning how do you group dates and do you use data model with PivotTable or not.
Dec 18 2021 12:44 PM
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.