Today, we are going to talk about how to filter many pivot tables at once. We have three pivot tables based on the same dataset from the left (Fig. 1).
If we want to filter many pivot tables at once, we have to connect then into one slice. We have to select one cell from the first pivot table, then find the PivotTable Analyze tab and Insert Slicer command, where we want to add the slicer by Country (Fig. 2)
After pressing OK, we have the slicer. We can change its size and color (Fig. 3).
Now, we can filter the first pivot table with the slicer. When we click on the name of a country, we can see changes in the first pivot table (Fig. 4). However, the second and the third pivot table did not change because they are not connected to the slicer.
In order to connect then, we select the slicer, then we click on the Slicer tab, then the Report Connection command, which opens up a window, where we can see three pivot tables. They have generic, default names, and when we aren’t sure if they are the right ones, we can look which sheet they are located in. Then, we check proper check boxes to connect all pivot tables and press OK (Fig. 5)
Now, we can see that the slicer is filtering all, three, connected pivot tables (Fig. 6)
When the pivot table name or the sheet name is not enough to identify the right one, we can change their names. When you select a proper pivot table, go to the PivotTable Analyze tab, then select the PivotTable Name command, and write the name you want. Let’s write PivotDate (Fig. 7). Giving names to pivot table makes it easier to work with them.
Now, that we have the slicer, we can easily filter three pivot tables at once (Fig. 8).
https://www.youtube.com/watch?v=6TDXBG-wdhM