Pivottable: Master filter for two pivotables

See more:

pivot-table

Dear all,

- I have sheet contain data as "DATA"

- I have PivotTable (PVT1) from "DATA" with:
+ Filter: Year, Quater
+ Colume: Month
+ Row: Location
+ Value: Money

- I also have PivotTable (PVT2) from "DATA" with:
+ Filter: Year, Quater
+ Colume: Location
+ Row: Month
+ Value: Money

- I would when I select "Year", "Quater" of PVT1, Year and Quater of PVT2 is changed same

Please help me, I have attached file example.xls in link
http://www.excelforum.com/excel-charting-and-pivots/885793-pivottable-master-filter-for-two-pivotable.html?p=3055183[^]

Thanks