Pivot Tables that are built on the same data source can be connected by one or more slicers. Please see here to learn how to insert a filter.
For example, we have a Pivot Table "Average of Salary" by region and we have a "Region" slicer. We add another Pivot Table "Count of ID". The two Pivot Tables are built on the same data source, and we want the slicer to connect the two Pivot Tables.
Step 1: Click anywhere in the second Pivot Table;
Step 2: Click "PivotTable Analyze" Tab in the Ribbon when working with Excel 365;
- The "Analyze" Tab if Excel 2019 or the "Options" Tab if Excel 2010.
Step 3: Click "Filter Connections" in the "Filter" section;
- If Excel 2010, please click the small triangle under "Insert Slicer", then select "Slicer Connections".
Tips: When you have many Pivot Tables to share one slicer, the easy way is to set up the first, and copy to others, then change others' calculations.
Step 4: In the new window, find and check the "Region" slicer from the list.
Step 5: Click "OK" at the bottom, you will find the two Pivot Tables are all changing when clicking on the slicer.
