pivot table pull down filter

S

Sanj

Everytime I added new data in the pivot table field and refreshed,items in
the pull down menu is not sorted in alphabetical order instead added in the
bottom of the list randomly. I mean when I create Pivot table first time pull
down has its item sorted aphabetically but when I update pivot table with new
data items that are added later is not sorted in alphabetical order. Is there
any work around for this?? thanks for you help
sanj
 
D

Debra Dalgleish

Right-click on the field button, and choose Field Settings
Click the Advanced button
Under AutoSort options, select Ascending, click OK, click OK
 

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

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
How to remove non-exist values in pull-down list in pivot table 1
Dynamic Naming of Form Button 3
Pivot Table cell values 1
Pivot Table Data Aggregation 0
Pivot Item Displaying Incorrect Value? 1

Top