Forum Discussion

Mohamed1988's avatar
Mohamed1988
Copper Contributor
Feb 20, 2021

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 and pressing enter, I get the below view:

 

I would like to replace "Dissatisfied" with a relative cell "M$1", also replace "X" with cell "$L1" so it should be working dynamic when I drag to right or down.

 

Any Help?

 

Thanks,

Share

Resources