Reference Cell in “GetPivotData” Function

[dmcgetti]

My function is working correctly when I manually enter the "CustomerAccoutNumber":

[COLOR=#242729][FONT=Consolas]=GETPIVOTDATA("[Measures].[Sum of SalePrice]",[[/FONT][/COLOR][COLOR=#242729][FONT=Consolas]2017Sales.xlsx]GMBlitzOct!$A$6,"[2017Sales].[CustomerAccountNumber]"," [/FONT][/COLOR][COLOR=#242729][FONT=Consolas][2017Sales].[CustomerAccountNumber].&[Z4049200]")[/FONT][/COLOR]

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?

 

[AFPathfinder]

100% untested, but this would be my guess:

[COLOR=#242729][FONT=Consolas]=GETPIVOTDATA("[Measures].[Sum of SalePrice]",[[/FONT][/COLOR][FONT=Consolas][COLOR=#242729]2017Sales.xlsx]GMBlitzOct!$A$6,"[2017Sales].[CustomerAccountNumber]"," [/COLOR][/FONT][COLOR=#242729][/COLOR][COLOR=#242729][FONT=Consolas][2017Sales].[CustomerAccountNumber].&[[/FONT][/COLOR][COLOR=#0000FF][FONT=Consolas]"&[COLOR=#242729][FONT=Consolas][/FONT][/COLOR]A2&"[/FONT][/COLOR][COLOR=#242729][FONT=Consolas]]")[/FONT][/COLOR]

 

[dmcgetti]

100% untested, but this would be my guess:

[COLOR=#242729][FONT=Consolas]=GETPIVOTDATA("[Measures].[Sum of SalePrice]",[[/FONT][/COLOR][FONT=Consolas][COLOR=#242729]2017Sales.xlsx]GMBlitzOct!$A$6,"[2017Sales].[CustomerAccountNumber]"," [/COLOR][/FONT][COLOR=#242729][FONT=Consolas][2017Sales].[CustomerAccountNumber].&[[/FONT][/COLOR][COLOR=#0000ff][FONT=Consolas]"&A2&"[/FONT][/COLOR][COLOR=#242729][FONT=Consolas]]")[/FONT][/COLOR]

Bingo!

Thank you!

 

[AFPathfinder]

You're welcome!