Sometimes using more than one pivot table is a mess. But it’s not a mess if you connect all the pivot tables with a single slicer. So do you know how to link a slicer with multiple pivot tables?
If you don’t know then follow this post and you will learn a superb trick to create some interactive dashboards.
Yes, that’s right.
Let’s say you are working on a dashboard where you are using multiple pivot tables. If you are able to connect a slicer to all the pivot tables you can control the entire dashboard with a single slicer.
In the above example, we have a single slicer to control both of the pivot tables.
NOTE: Pivot Tables are one of the INTERMEDIATE EXCEL SKILLS.
Steps to Connect a Slicer to Multiple Pivot Tables
Below are the steps which you need to follow to create a multi-linked slicer:
- First of all, take two or more pivot tables to connect a slicer.
- After that, select a cell in any of the pivot tables.
- From here, go to Analyze → Filter → Insert Slicer.
- Now from the “Insert Slicer” dialog box, select the column to use as a filter in the slicer and click OK.
- At this point, you have a slicer in your worksheet which can filter the pivot table in which you insert it.
- Next, you need to connect it to the second pivot table.
- From here, select the slicer and go to Analyze → Slicer → Report Connections.
- You will get a new dialog box with the list of pivot tables that are in your workbook.
- In the end, just tick mark all the pivot tables and click OK.
Congratulations! You have connected the slicer with two pivot tables.