G
GetPivotMe
I am new to SQL Server OLAP cubes.
The following is the formula in question.
=GETPIVOTDATA("[Measures].[Units]",$A$16,"[Markets]","[Markets].[All
Markets].[South].[Virginia].[Salem]","[Platform Types]","[Platform
Types].[All Platform Types].
The following is the formula in question.
=GETPIVOTDATA("[Measures].[Units]",$A$16,"[Markets]","[Markets].[All
Markets].[South].[Virginia].[Salem]","[Platform Types]","[Platform
Types].[All Platform Types].
")
Using normal Excel pivots, I can subsitute excel addresses in the
Getpivotdata function to automate my work. For example,
GETPIVOTDATA("Sum of
"&TRIM(ColList!$H$5),INDIRECT(RegionPivotStartRef),"REGION",$A7,"ACTIVATION_MONTH",DATE(YEAR(G$5),MONTH(G$5),1)
Is this possible with SQL Server cubes? I have tried various ways to
reference Excel cells, but keep getting #REF errors.
Any assistance would be appreciated!
Thanks!
Using normal Excel pivots, I can subsitute excel addresses in the
Getpivotdata function to automate my work. For example,
GETPIVOTDATA("Sum of
"&TRIM(ColList!$H$5),INDIRECT(RegionPivotStartRef),"REGION",$A7,"ACTIVATION_MONTH",DATE(YEAR(G$5),MONTH(G$5),1)
Is this possible with SQL Server cubes? I have tried various ways to
reference Excel cells, but keep getting #REF errors.
Any assistance would be appreciated!
Thanks!