Is there an efficient way to add a series of cells in a pivot table using GetPivotData function and not the cell reference?
We can definitely do that using "=getpivotdata(......)+getpivotdata(......)+.....", but I would like a more efficient way to do that.
I wouldnt prefer using the cell reference because it would mess up the cells when some more data is added and the contents of pivot changes.