make Pivot table show only available values in dropdowns
 

Hello all.
I have a major pivottable (20+ fields, 30000+ records). this makes the
dropdown menus very hard to operate (due to the hugh amount of values).

Is there any way to make the dropdowns show only available values left after
the previous filtering?
I've noticed auto-filter does that automatically, but I cant find a way to
do that in the pivot.

make Pivot table show only available values in dropdowns
 

There's nothing built into the pivot table that will create dependent
dropdown lists in the page fields.

Yaron Assa wrote:
Hello all.
I have a major pivottable (20+ fields, 30000+ records). this makes the
dropdown menus very hard to operate (due to the hugh amount of values).

Is there any way to make the dropdowns show only available values left after
the previous filtering?
I've noticed auto-filter does that automatically, but I cant find a way to
do that in the pivot.


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

make Pivot table show only available values in dropdowns
 

well, at least i know to stop searching.

thanks.

"Debra Dalgleish" wrote:

There's nothing built into the pivot table that will create dependent
dropdown lists in the page fields.

Yaron Assa wrote:
Hello all.
I have a major pivottable (20+ fields, 30000+ records). this makes the
dropdown menus very hard to operate (due to the hugh amount of values).

Is there any way to make the dropdowns show only available values left after
the previous filtering?
I've noticed auto-filter does that automatically, but I cant find a way to
do that in the pivot.


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