Forum Discussion
Help needed for pivot table filters
How should I rearrange the pivot table filter options to make them appear in the correct order? Thank you!
EricZHcheese Your labels seem to be texts, so Excel sorts them as such.
Change the label "1-2" to "01-02" and it should sort above "10-19". Similar for the others where ypu have single digits.
Riny_van_Eekelen Thank you for your reply. Yes, they are texts, but something is still wrong here after I have added 0 in front.
EricZHcheese Don't know. Would have to see your file, but closing down soon. Perhaps someone else can step in.