2 Pivot Table Filtering

Question

I have a workbook. This has 2 sheets. PT1 and PT2. PT1 has a pivot table named PivotTable1, whereas PT2 has a pivot table named PivotTable2. Both the pivot tables have a filter with field Cust PO. Cust PO has multiple entries such as 4578, 48392, 9982 and more. When I filter PivotTable1 with a specific Cust PO like 4578, I want PivotTable2 to be automatically reflected with the same filter. How do I achieve this? If there is a vba code, please help me with the same.

Answer 1

Make sure both pivot table share the same pivot cash. Then you can put a Slicer on one and connect it to the other as well. Then, one slicer will control both pivot tables.

In the picture below I created two pivot tables based on the same data table. Then I put a slicer on the first. Select the slicer and then 'Report Connections' on the Slicer ribbon. Check both pivot table names and the slicer will control both. Even when they are on different sheets.