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 & "]",
Mohamed1988's avatar
Mohamed1988
Copper Contributor
Feb 20, 2021

SergeiBaklan , at least it works successfully, much appreciated!