SOLVED

How to organize within a dropdown box - pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2221013%22%20slang%3D%22en-US%22%3EHow%20to%20organize%20within%20a%20dropdown%20box%20-%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2221013%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20all.%20I%20am%20using%20%22Weeks%22%20in%20the%20Filter%20section%20of%20a%20pivot%20table%20and%20when%20I%20click%20into%20the%20dropdown%20box%2C%20the%20weeks%201-52%20are%20not%20in%20order%20of%20smallest%20to%20largest.%20Is%20there%20any%20way%20I%20can%20get%20the%20items%20inside%20a%20dropdown%20box%20to%20organize%20better%20(preferably%20smallest%20to%20largest)%3F%20Many%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2221013%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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 (Contributor)
Solution

@slohombre 

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

 

Thank you....that was it!