Forum Discussion
Mohamed1988
Feb 20, 2021Copper Contributor
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,
- Mohamed1988Copper Contributor
SergeiBaklan , at least it works successfully, much appreciated!
Mohamed1988 , you are welcome