Hi there,
I got an workbook with 8 pivot tables of 8 different data sources. All 8 data sources have 1 equal column with week numbers. Somehow I want to be able to use 1 slicer or one other button that filters the weeks that I select on this slicer/button on all 8 pivot tables. Is this possible?
* Just simple Pivot tables connections is not possible because therefore I need 1 data source.
* Report connections after 'Use this workbook's datamodel' is also not possible because when I try to link the week columns I get the error 'Both columns contain duplicate values'. But this I can't change because in all 8 data sources there are many rows that contain te same week number.
Is there an other solution?
Kind regards,
Bert
Bookmarks