J
jaroscak
Hi there
I am trying to figure out how to change the absolute reference created
automatically by GETPIVOTDATA to a cell reference.
E.g. =GETPIVOTDATA("[Measures].[Sum]",OLAP!$A$3,"[Group]","[Group].[All
Group].[Product A]"
I need to change the .[Product A] part to some cell reference like A14
to be able to copy down the whole formula.
Moreover the GETPIVOTDATA usually consist of multiple references which
get created automatically and it is a nightmare to copy them.
Any help is appreciated.
Thanks, Pab
I am trying to figure out how to change the absolute reference created
automatically by GETPIVOTDATA to a cell reference.
E.g. =GETPIVOTDATA("[Measures].[Sum]",OLAP!$A$3,"[Group]","[Group].[All
Group].[Product A]"
I need to change the .[Product A] part to some cell reference like A14
to be able to copy down the whole formula.
Moreover the GETPIVOTDATA usually consist of multiple references which
get created automatically and it is a nightmare to copy them.
Any help is appreciated.
Thanks, Pab