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. You will learn a superb trick to create some interactive dashboards.
Let’s say you are working on a dashboard where you are using multiple pivot tables and if you are able to connect slicer to all the pivot tables you can control entire dashboard with a single slicer.
In above example, we have a single slicer to control both of the pivot tables.
Just follow these simple steps to insert a multi-linked slicer in pivot tables.
Congratulations! you have connected the slicer with two pivot tables.
Important: You can only connect a slicer with more than one pivot table using the same data source.
I love to link a slicer to multiple pivot tables when I have to work on dashboards.
What do you thing? Do you like this tip?
Share your views with me in the comment section, I'd love to hear from you. And, please don't forget to share this tip with your friends.
Must Read Pivot Table Tips