Forum Discussion

LorenzoClg's avatar
LorenzoClg
Copper Contributor
Oct 05, 2022

GetPivotData function with Power Pivot

Hi all,

 

I am having issue with the following formula:

=GETPIVOTDATA("[Measures].[Sum of Received]",Sheet1!$H$1,"[Items].[Item name]","[Items].[Item name].&[@[Item name]]")

 

Can someone tell me what is wrong with it and how to fix it.

 

I have troubleshooted the formula and it appears to be an issue with &[@[Item name]]. Can I not reference a table column in a getpivotdata 

No RepliesBe the first to reply

Resources