Mar 18 2021 01:18 PM
Hi, all. I am using "Weeks" in the Filter section of a pivot table and when I click into the dropdown box, the weeks 1-52 are not in order of smallest to largest. Is there any way I can get the items inside a dropdown box to organize better (preferably smallest to largest)? Many thanks.
Mar 18 2021 02:29 PM
SolutionMar 18 2021 02:56 PM
Mar 18 2021 02:29 PM
SolutionMy guess is that your "weeks" are text. Change them to numbers.