make Pivot table show only available values in dropdowns

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table help 1
Pivot Table Page Field value from cell in another worksheet 3
including zero values in a pivot table 2
Filter pivot table zero values 1
Top X% in Pivot Tables 1
XL2007: Pivot table date filter 1
Single Filter to change all Pivot Tables in a Workbook 8
Value not showing in pivot table 7

Back
Top