Pivot Table - Column Drop Down Lists...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a Pivot Table that I use to to compare records with past history. I
select the records for the information I want to use for comparision from a
Column Drop Down list.

How is it that I get the Items in the drop down list to appear in alphabetic
order?

Thank you in advance!
 
Right-click on the field button
Choose Field Settings
Click Advanced
Under AutoSort options, choose Ascending.
Click OK, OK
 
Thank you very much!

Debra Dalgleish said:
Right-click on the field button
Choose Field Settings
Click Advanced
Under AutoSort options, choose Ascending.
Click OK, OK
Click to expand...
 
Back
Top