Linking a Slicer to Multiple pivot tables
We can link our slicer to multiple pivot tables which can build a very interactive dashboard. To do so follow the below steps:
Step 1: Right-click on the slicer and select the option of Report Connections.
Step 2: After that, you will see a menu like this.
Step 3: Now, select all the table names on which you want your slicer to work.
Suppose in our example of the IMDb movies database, I want both the budget and gross revenue to be displayed for all the comedy films in U.S.A and U.K.
So here our slicer works on both the pivot tables.
Pivot Table Slicers in Excel
Slicers are the visual representation of filters. By using a slicer, we can filter our data in the pivot table by just clicking on the type of data we want. Slicers are found in the Analyze tab of the pivot table tools. We have an option called Insert Slicer and on clicking it, we have to select the column on the basis of which we need to filter our data.