SOLVED

How to organize within a dropdown box - pivot table

Brass Contributor

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.

2 Replies
best response confirmed by slohombre (Brass Contributor)
Solution

@slohombre 

My guess is that your "weeks" are text. Change them to numbers.

 

Thank you....that was it!
1 best response

Accepted Solutions
best response confirmed by slohombre (Brass Contributor)
Solution

@slohombre 

My guess is that your "weeks" are text. Change them to numbers.

 

View solution in original post