I have 5 worksheet, each with a different data set, but all have a common data type (column), I have inserted a table in each worksheet, on a new sheet I have inserted a Pivot Table, Then used the data model to generate 5 new Pivot Tables, each looking at one of the tables in each of the WorkSheets. I have created a relations ship between the first table and each of the 4 other tables based on the one common types (column), I have inserted a slicer for the first Pivot Table and then with the Report Connections menu have linked the slicer to the other 4 pivot tables... I have learnt this from You Tube... and it was fairly straight forward.. But it doesn't seem to work.. any suggestions??
Bookmarks