Pivot Table - Column Drop Down Lists...
 

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!

Pivot Table - Column Drop Down Lists...
 

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


Steve wrote:
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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table - Column Drop Down Lists...
 

Thank you very much!

"Debra Dalgleish" wrote:

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


Steve wrote:
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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html