Excel Pivot Table Filters - How to Make One Filter Drop Down Dependent on Another Drop Down?
<p>I have a pivot table with two drop down filters. I want the data in the second drop down to be refined based on the selection of the first drop down.</p>

<p>i.e. If the table stored city/country data and the two filters were Country and City, I'd want the City drop down to only contain cities that are in the Country chosen in the first drop down.
<a href="http://i.stack.imgur.com/fUVRr.png" rel="nofollow">Here is a screengrab of what I'm talking about.</a></p>

<p>Any tips are appreciated.</p>

<p>Thanks</p>