Help with GETPIVOTDATA drag down formula

[ExcelAtEverything]

Hello,

I'm trying to use GETPIVOTDATA to fill in the "GS$" column shown below, with info pulled from the Pivot Table next to it (but on a different sheet in my WB). I'm running into the common problem where I grab the 1st cell no problem, but then when I drag the cell with my GETPIVOTDATA formula down, it continues grabbing the sales number for the first Org # (Org 237), instead of next grabbing the info for Org 839, etc.

=GETPIVOTDATA("[Measures].[Sum of Line Item Total]",'Yest GS'!$B$3,"[Monthly Orders Reports].[Date]","[Monthly Orders Reports].[Date].&[2021-03-27T00:00:00]","[Monthly Orders Reports].[Org #]","[Monthly Orders Reports].[Org #].&[237]")
***"Monthy Orders Reports" by the way is just the name of the data folder where all of my data is.
I tried replacing the last part :
"[Monthly Orders Reports].[Org #].&[237]"
with this:
E6 (E6 is the cell below which contains the number "237"
but it's giving me a #REF error.

Could someone please help me figure this out?

Green/white table is on "Proj" tab: Black/white Pivot Table is on "Yest GS" tab:

 

[mart37]

Is Monthly Orders Reports the name of the left table?

 

[ExcelAtEverything]

Hi thanks mart37! That brings me a #REF error as well.

 

[mart37]

And: [@Org #]
Or: [@[Org '#]]

 

[ExcelAtEverything]

Is Monthly Orders Reports the name of the left table?

No, it's the name of the folder on my desktop which is holding all of the data sheets for these Pivot Tables. I'm pretty new to Pivot Tables, so I'm not sure why that's included in this GETPIVOTDATA formula. I just typed "=" and clicked on the needed cell in order to build that formula.

 

[ExcelAtEverything]

[@Org #]

=GETPIVOTDATA("[Measures].[Sum of Line Item Total]",'Yest GS'!$B$3,"[Monthly Orders Reports].[Date]","[Monthly Orders Reports].[Date].&[2021-03-27T00:00:00]","[Monthly Orders Reports].[Org #]",[@Org #])

 

[mart37]

The name of the folder uses Excel when you have the table in an other workbook.
But in your case the tables are in the same workbook on two different sheets.
You can find the name of your left table with: DESIGN - PROPERTIES - TABLENAME
And for your right table: ANALYZE - PIVOT TABLE - NAME OF PIVOT TABLE

 

[mart37]

Have you tried this: [@[Org '#]]
Maybe the title ORG # isn't correct. The sign # is in my example replaced with '#

 

[ExcelAtEverything]

The name of the folder uses Excel when you have the table in an other workbook.
But in your case the tables are in the same workbook on two different sheets.
You can find the name of your left table with: DESIGN - PROPERTIES - TABLENAME
And for your right table: ANALYZE - PIVOT TABLE - NAME OF PIVOT TABLE

Left table: Yesterday
Right Table: PivotTable3

 

[ExcelAtEverything]

Have you tried this: [@[Org '#]]
Maybe the title ORG # isn't correct. The sign # is in my example replaced with '#

This gives me a #REF error.