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&"]")

Resources