pivot table - drop down filter box has 10% of items out of order

  • Thread starter Thread starter davidsokay
  • Start date Start date
D

davidsokay

Most of my numeric items appear in the drop down filter box in order. . I
know all these are numeric and I even tried to move it down to within the
pivot table report and got same problem. In excel 2007, I cannot figure out
how to ensure the drop down is in alphabetical order. This is a productivity
killer when looking for certain items. Any ideas?
 
If you sort the field in the pivot table, the items in the field's
dropdown list should also be sorted.

To sort a column field, select a cell in the column area, and click the
A-Z button on the tool bar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Report Filter Sorting 3
Filtered drop down list 2
Excel Pivot Table - Sort Report Filter Values 3
Top X% in Pivot Tables 1
how do I control the sort order of a filter in a pivot table? 1
Pivot Table - Column Drop Down Lists... 2
How to refresh drop-down list of pivot table 3
Pivot table drop downs 1

Back
Top