Hello,

I have two pivot tables that have the same filter column and row labels but different values.

Is there a way that I can cause changing the filter on one to effect them both?


I.e. my filter is markets, if i select the australian market on my "sales" table, i'd like the respective "forecast" table to automatically filter to just australia as well. The reason I want to do this is because I have a normal (not pivot) chart that calls from the grand total section from both these tables. In order for my data to have any meaning, i need to be drawing data from the same markets.