1
1
My function is working correctly when I manually enter the "CustomerAccoutNumber":
=GETPIVOTDATA("[Measures].[Sum of SalePrice]",
[2017Sales.xlsx]GMBlitzOct!$A$6,"[2017Sales].[CustomerAccountNumber]","
[2017Sales].[CustomerAccountNumber].&[Z4049200]")
But I would like to replace the "Z4049200" with a cell reference so I can copy and drag down for multiple rows, is it possible?