Forum Discussion
Solved
Link a segment to multi pivot tables
Hi, I'm trying to create 1 pivot table and then generate two graphics for the same pivot table. The first graphic will contains different data then the second one, but when I make a change, its don...
I found the problem. Is related to the fact that the pivot table, the charts, and the slices was in a different sheet than the data table.
Problem solved by creating the pivot table in the same data table sheet.
I'm not sure, but it looks like the slicer is inserted for the source table, not for PivotTable. Other words, did you stay on source table or on created PivotTable inserting the slicer? The latest shall work, you my connect other PivotTables/Charts to it. If only all of them were built with adding data to data model or all without adding.
- The slicer is inserted for the pivot table... I selected the pivot table to create the slicer.
SergeiBaklan Pivot table