Synchronize PivotTable Items
I'm trying to synchronize three pivottables to be exact. The page-by
field was fairly simple.
Incase someone is trying to do this here's a real simple suggestion:
RVPName = PageBy cell name
PTName = Range("RVPName").Value
Sheets("Sales
Rep").PivotTables("SalesRepPT2").PivotFields("Regi onal
VP").CurrentPage _
= PTName
Sheets("Sales Rep Graph
Data").PivotTables("RVPH2H").PivotFields("Regional VP").CurrentPage _
= PTName
Sheets("Sales Rep Graph
Data").PivotTables("RVPPie").PivotFields("Regional VP").CurrentPage _
= PTName
What I cannot figure out is how to synchronize the items. If a
SalesRep drop-down contains John, Mary and Jane and the "master"
pivottable selects John and Jane I'd like the other two to do the
same. Is this possible? TIA.
|