Pivot Table Dropdown Updating on Fly?

Padgoi

New member
Joined
Apr 17, 2013
Messages
3
Reaction score
0
Points
0
Hi All,
I'm in the process of creating a pivot table but I've run into a problem. My pivot table has a drop down menu so I can choose which areas to filter and my pivot table updates accordingly. The problem is, I need the drop down to update on the fly when choosing an option from one of the other filters.

Context: I have two rows of data, one with city and one with country. When I choose the country in one of the drop down filters, I want the city drop down to update accordingly so it only shows those cities in that country and not all of the other cities in other countries. Is there any way I can do this? I'm sure there is, but I have no idea how. Any help would be greatly appreciated. Thanks in advance.
 
Any help at all would be greatly appreciated for this. Thanks!
 
I'm afraid that unlike autofilters, the pivot table dropdowns do not respect other filters that are in place.
 
You sir are a God among men. Thank you!!!
 
Back
Top