I am trying to change the filter in two pivot tables at the same time by selecting the region from a drop down list. However, I cannot make the the filters change even based on drop down list selection.

This is the code I am using:

Please Login or Register  to view this content.
Thank you for your help.