Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables

Hi - Looking for some help on the following:
I have 3 pivot tables on one sheet sourcing from the same data set. I have the same Report Filter (Month/YR) on each Pivot table and the same Row Labels item as well (Material Numbers). I would like to select single values on Report Filter and multiple values on the Row Labels on the first Pivot table, and would like the same selections shown on the other two pivot tables. I have read a few posts and tried some of the code but when i applied a filter on the first pivot table, the filters did not change on the second and third pivot tables.

Sample of sheet for easier reference Sample Tables - Updated 02 15 13.xlsx


http://www.excelforum.com/excel-gene...-criteria.html

http://www.excelforum.com/excel-gene...ot-tables.html

Please Login or Register  to view this content.