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.

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

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