GETPIVOTDATA Not Dragging Down Correctly

[ExcelAtEverything]

Hello,
I have a document which will be a daily report for a store which will report on sales and other metrics. The main sheet gets its information from Pivot Tables (each located on a separate tab). The Pivot Tables get their information from Excel documents which are stuffed into specific folders on my desktop, and I get that information into the Pivot tables via Power Query where it's then just loaded into the data model (which again, feeds the Pivot Tables).

The GETPIVOTDATA formula below is for the "Main" sheet "IPT" row. (IPT is calculated by taking # of items sold divided by total number of transactions. The formula works, but when I pull it down, it keeps returning the same number instead of auto-adjusting the formula so that it goes for the next row down, etc. How can I adjust the GETPIVOTDATA formula below so that when I drag it downward, it works correctly? I tried changing both instances of "[Monthly Orders Reports].[Org #].&[237]" into this: "[Monthly Orders Reports].[Org #].&["&[@[Org '#]]&"]"), but it doesn't work.

Note: The Monthly Orders Reports is the folder in my desktop which dolds the info for the Pivot Tables used to get the IPT number.
=GETPIVOTDATA("[Measures].[Sum of Quantity]",'Item Totals Yest'!$B$3,"[Monthly Orders Reports].[Org #]","[Monthly Orders Reports].[Org #].&[237]","[Monthly Orders Reports].[Date]","[Monthly Orders Reports].[Date].&[2021-03-27T00:00:00]")/GETPIVOTDATA("[Measures].[Distinct Count of Order ID]",'Trans Count Yest'!$B$3,"[Monthly Orders Reports].[Org #]","[Monthly Orders Reports].[Org #].&[237]","[Monthly Orders Reports].[Date]","[Monthly Orders Reports].[Date].&[2021-03-27T00:00:00]")

Sheet: Main
Table: Yesterday
Description: This is the main home page of the report which contains the all the results from all of the queries, all on one sheet.


Sheet: Trans Count Yest
Pivot Table Name: Trans_Cnts_Yest
Description: Total Transactions Yesterday

Sheet: Item Totals Yest
Pivot Table Name: Item_Tot_Yest
Description: Total Items Sold Yesterday

 

[mart37]

I say that because I thought that when you have only the date column you then needed the date statement. And that without statement the grand total is used. When I removed the grand total then I get an error.

 

[ExcelAtEverything]

I say that because I thought that when you have only the date column you then needed the date statement. And that without statement the grand total is used. When I removed the grand total then I get an error.

Mart37, I see what you mean now. I keep getting errors as well. Initially my computer froze an hour ago and I lost all your fixes from earlier today. When I pulled it back up, I entered this latest fix and it worked great. But then I refreshed it to include all of my new data, and got all the errors. So anyway, I added the totals in and now it works great again. Thanks again bro! You have really come thru for me with this entire issue and I so greatly appreciate it! ???

 

[ExcelAtEverything]

AAlso mart37, I've only known how to use Pivot Tables for a few days now, and I had no idea about that totals line and it causing errors if it's not there for whatever reason. I still don't quite understand why the sheet throws errors if the grand totals line isn't in. I've been looking it up online for about 15 minutes now but haven't been able to find anything about it yet. I'm going to keep searching for that so that I can fully understand it, but just wanted to reach back out and tell you thanks for that!

 

[ExcelAtEverything]

Mart37, if you're stil feeling lucky.... Same sort of issue, same table, slightly different situation. Just thought I'd try you first since you seem to be on a roll for me here! LOL
Extracting info from Grand Total column of Pivot Table