multiple pivot tables but common rows and slicers

jono

New member
Joined
Dec 31, 2015
Messages
24
Reaction score
0
Points
1
Excel Version(s)
2016
Hi

I have a number of pivot tables from various sources on different sheets and have created a 'Dashboard' full of graphs and tables, along with slicers to filter the output.

However I now have 5-6 different sections with slicers, which all contain Year, Qtr, Month, from the different pivot tables.

As I'm unable to contain all the data in one pivot table and have single slicers, is there a means of being able to link the slicers together so if I choose a year for example, all the slicers with the same availability also change?

Thank you
 
I am looking for the same thing. I'll let you know if I see anything.
 
Hi

I found this and the first 30 seconds or so of the video fixed the majority of what I needed and the rest of the video helped with the rest.

https://www.youtube.com/watch?v=1fOeIS-UpNU

It might help you resolve your slicers too.

Jon
 
Back
Top