how do I control the sort order of a filter in a pivot table?

G

Grizz

I have a large dataset that I am running a pivot table on...the dataset
contains 300 customer names. I use customer name as a filter. In the filter
drop down, the first half of the list is in alphabetical order that ends in a
(blank) then the second half of the filter list is randomly sorted customer
names. Makes it hard to find what I need. Anyone have any ideas?
 
D

Debra Dalgleish

Temporarily move the customer name field to the row area.
In Excel 2007:
Right-click on the field heading, click Sort>Sort A to Z
Move the field back to the Report Filter area

or, in Excel 2003 and earlier:
Right-click on the field heading, click Field Settings
Click Advanced
Click Ascending, then click OK, twice
Move the field back to the Report Filter area
 

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 Sort Order 1
Excel Pivot Table - Sort Report Filter Values 3
pivot table - drop down filter box has 10% of items out of order 2
2007 - Pivot Talbe: Sort Report Filter 2
Pivot Table Help 1
Sort choices in filter in pivot table 1
Pivot Table Data Column Sort Excel 2007 1
date filter in a pivot table 1

Top