Help needed for pivot table filters

Copper Contributor

screenshot.png

 

How should I rearrange the pivot table filter options to make them appear in the correct order? Thank you!

3 Replies

@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 screenshot2.png 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.