I have raw data for 2012 to 2017 - each in a worksheet. (named Data2017, Data2016 ……etc.)
They are connected via a tab called key.
I created a Pivot table from 2017 Raw data, then copied it to created pivot tables for each year by editing only the date fields.(named Final2017, Final2016 …..etc)
I tried to create slicers which will adjust selected value for all graphs.
I can create the slicers and connect it to each other, but my selection affect only the table for which it was created and not all pivot tables.
Your assistance will be appreciated greatly.
They are connected via a tab called key.
I created a Pivot table from 2017 Raw data, then copied it to created pivot tables for each year by editing only the date fields.(named Final2017, Final2016 …..etc)
I tried to create slicers which will adjust selected value for all graphs.
I can create the slicers and connect it to each other, but my selection affect only the table for which it was created and not all pivot tables.
Your assistance will be appreciated greatly.
