pivot table pull down filter

G

Guest

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
 
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

pivot table question 1
Pivot Item Displaying Incorrect Value? 1
display filter selection from menu 2
entry not removed in pivot table pull down filter 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Sort Order 1
Pivot Table Comparison 1
Pivot Tables 2

Top