Sep 13 2020 06:47 AM
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 done for both graphics.
So, I create 2 pivot table form the same data and I generated 2 graphics, each one contains different results, and it is ok. The problem is when I try to create a segment:
I need to connect this segment to both pivot tables, so I tried to select it and I go to Options > Report connections, I can find only 1 pivot table, the second one is invisible.
I tried to create each pivot table on a different pages, but the problem is the same.
Any suggestion?
Sep 13 2020 10:31 AM
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.
Sep 13 2020 11:49 AM
Sep 13 2020 11:59 AM
Sep 13 2020 02:04 PM
SolutionI 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.
Sep 14 2020 01:34 AM
Sep 13 2020 02:04 PM
SolutionI 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.