Forum Discussion
Three pivot tables
I have to create essentially the same pivot table 3 times, but the only variable is that I need one to show days, the other to show weeks, and the last to show months.
The problem I encounter is when I create the second pivot table and group by weeks, it makes the first pivot table do the same thing.
I tried using the pivot table wizard to create an un-linked 2nd and 3rd table, which solved the problem of making the other pivot tables change their grouping but then when I created slicers, the slicer only impacts one of the pivot tables and there is no way to link the slicer to the other pivot tables.
How do I get it where the pivot tables do not change when I change the grouping, so I can have one slicer for all of the pivot tables?
The easiest way is to add data to data model creating PivotTable
Other way is to separate caches, you may google for guidance, but I don't see practical reasons to use such method.
