Forum Discussion

spamitovic's avatar
spamitovic
Copper Contributor
Sep 13, 2020
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...
excel
Formulas and Functions
office 365
  • spamitovic's avatar
    spamitovic
    Sep 13, 2020

    spamitovic 

    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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 13, 2020

spamitovic 

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.

spamitovic's avatar
spamitovic
Copper Contributor
Sep 13, 2020
The slicer is inserted for the pivot table... I selected the pivot table to create the slicer.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 13, 2020

    spamitovic 

    And here is the name of PivotTable or PivotChart?

      • spamitovic's avatar
        spamitovic
        Copper Contributor
        Sep 13, 2020

        spamitovic 

        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.

Resources