make Pivot table show only available values in dropdowns

Y

Yaron Assa

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

Debra Dalgleish

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