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 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