Forum Discussion
LorenzoClg
Oct 05, 2022Copper Contributor
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