Pivot Table Filtered - How to just show filtered data in pull-down menu from a different list?

[olimits7]

Hi,

I have a pivot table where lets say I filtered by "Continent: Europe" and then have another filter for "Country" but when I look at the country pull-down menu it's still showing all countries from all continents; how can I set this up so if I select "Europe" from the pull-down menu it will just show "Europe" countries?

Thank you!

 

[RoryA]

You can't. The dropdowns in pivot tables don't work the same way as autofilter ones. Best you could do is to use slicers instead.

 

[olimits7]

Oh ok, thank you! I tried using slicers and I got the same result. I added 2 slicers, one for "Continent" equal to Europe, and then another slicer for "Country" but in the country slicer it still shows ALL countries instead of just European countries. Is there an option I have to set in the slicer so it only shows countries that match the Europe slicer?

Thank you!

 

[RoryA]

It will still show them but by default they should be greyed out and listed at the end. Are they not?

 

[olimits7]

No, it still shows all of them listed in the slicer and not at the bottom greyed out. Could it be because I have those columns listed in the pivot table filter section? I can try removing them from there and just using the slicers only.