Hi People,
I have a Pivot Table which has three page fields - Region, District, Store Name. If you select a Region, I would like the Pivot to update the District & Store Name page field drop down menu to reflect ONLY the stores present in the selected Region. In other words, once a selection is made in any one of the three page fields, the others should only display ones that are mutually existant.
I know how to create a series of drop down menus which effectively do this (i.e. Drop down select in the first box the Country Name, and then the corresponding office location for that country are the available options in the second drop down menu, and so on, however I cant figure out a way to do this for a Pivot Table with multiple page fields?
Any help much appreciated!
Thanks
I have a Pivot Table which has three page fields - Region, District, Store Name. If you select a Region, I would like the Pivot to update the District & Store Name page field drop down menu to reflect ONLY the stores present in the selected Region. In other words, once a selection is made in any one of the three page fields, the others should only display ones that are mutually existant.
I know how to create a series of drop down menus which effectively do this (i.e. Drop down select in the first box the Country Name, and then the corresponding office location for that country are the available options in the second drop down menu, and so on, however I cant figure out a way to do this for a Pivot Table with multiple page fields?
Any help much appreciated!
Thanks