GETPIVOTDATA Syntax Error

[ExcelAtEverything]

Hello, I'm having trouble changing the BOLD portion of the following GETPIVOTDATA formula, to be dynamic. I've edited the Date & the Year parts already, but I keep getting a syntax error when I attempt change on the "Org #" part. The "Org #" part shown here is still from the original static code.

=GETPIVOTDATA("[Measures].[Sum of Total Discount]",'LY Discounts Yearly'!$B$3,
"[LY Orders Data Tab - Discounts].[Org #]","[LY Orders Data Tab - Discounts].[Org #].&[237]",
"[LY Orders Data Tab - Discounts].[Date]","[LY Orders Data Tab - Discounts].[Date].&["&TEXT($G$3-366,"yyyy-mm-dd") & "T00:00:00]",
"[LY Orders Data Tab - Discounts].[Date (Year)]","[LY Orders Data Tab - Discounts].[Date (Year)].&"&"["&YEAR($G$3-366)&"]")

My attempt which gave the syntax error was:
"[LY Orders Data Tab - Discounts].[Org #]","[LY Orders Data Tab - Discounts].[Org #].&[" &[@[Org '#]]& "]",

Thanks!

 

[RoryA]

That looks correct to me.

 

[ExcelAtEverything]

Me too. but I keep getting a syntax error.

 

[RoryA]

What's the whole formula as you are trying to enter it, and which part is highlighted after the error? I can enter it in a cell without issue.

 

[ExcelAtEverything]

Hi Rory! Thx.

=GETPIVOTDATA("[Measures].[Sum of Total Discount]",'LY Discounts Yearly'!$B$3,
"[LY Orders Data Tab - Discounts].[Org #]","[LY Orders Data Tab - Discounts].[Org #].&[" &[@[Org '#]]& "]",
"[LY Orders Data Tab - Discounts].[Date]","[LY Orders Data Tab - Discounts].[Date].&[2020-08-31T00:00:00]",
"[LY Orders Data Tab - Discounts].[Date (Year)]","[LY Orders Data Tab - Discounts].[Date (Year)].&"&"["&YEAR($G$3-366)&"]"),
[@[Adj Total for 1st partial month LY]])

 

[RoryA]

Is that formula in the table? If not, you need to include the table name.

 

[ExcelAtEverything]

Rory, you sir are a Jedi. Your Excel prowess is inspiring. Thank you! ?

 

[RoryA]

Glad we could help.