Microsoft Excel - Multiple Pivot Tables - Asked By jezza on 16-Mar-13 06:01 AM


I have 3 data table I have made pivot tables from. Each Pivot table records different data and the data can not be combines. What I have though is common columns which are my main Report Filter (Country) and Row Label ( Purchaser). Is there a way I can have it so I can have it so when I change the report filter for a Country it changes it in all 3 tables. In esscence have it as a high level filter.