Forum Discussion

Mohamed1988's avatar
Mohamed1988
Copper Contributor
Feb 20, 2021
Solved

How to use the cell reference with GetPivotData

Hi Team,   I am trying to build relative references to an OLAP cube using the GETPIVOTDATA function "Excel 365".  When I create the initial formula by typing "=", arrowing onto a field in the cube...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 20, 2021

    Mohamed1988 

    Within formula you may change

    .&[Dissatisfied]",
on
.&[" & M$1 & "]",
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 20, 2021

Mohamed1988 

Within formula you may change

.&[Dissatisfied]",
on
.&[" & M$1 & "]",
Mohamed1988's avatar
Mohamed1988
Copper Contributor
Feb 20, 2021

SergeiBaklan , at least it works successfully, much appreciated!

    • Nico_Beckers's avatar
      Nico_Beckers
      Copper Contributor
      Feb 22, 2021

      SergeiBaklan 

       

      i am having a similar problem but your suggestion doesn't work for me. Can you see what is wrong here?

      =GETPIVOTDATA("[Measures].[Sum of Quantity On Hand]",'TWE Pivot'!$A$3,"[Table2].[Item Number]","[Table2].[Item Number].&["&$A3&"]","[Table2].[Description]","[Table2].[Description].&["&$B3&"]")

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 13, 2023

        Nico_Beckers 

        To be sure, are you on data model PivotTable or on cached PivotTable? Formula

        =GETPIVOTDATA("[Measures].[Sum of Quantity On Hand]",
    'TWE Pivot'!$A$3,
    "[Table2].[Item Number]",
    "[Table2].[Item Number].&[" & A3 & "]",
    "[Table2].[Description]","[Table2].[Description].&[" & B3 & "]")

        Please check in second sheet of the attached file.

Resources