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