Extracting info from Grand Total column of Pivot Table

[ExcelAtEverything]

Hello,

In the following table (which resides on a tab called "Main", in a table named "Yesterday"), I need to populate column "AI$" (column R) with the current aging inventory grand totals for each Org #. Basically I'm asking for help figuring out how to grab the grand totals only for each Org # I can't seem to get it working using Index function. I also need it written in such a way so that I can pull the formula down to the other cells and it will translate correctly.

The data for the above table resides in the Pivot Table (actually the Pivot Tables are getting their data from Queries & a Data Model). The Pivot Table is currently 144 rows long (it will be different from day to day since this Pivot Table (named PivotTable3) filters the inventory to only show =>90 days old, as is shown below in row #4). Since it's 144 columns wide, I'll just paste the row so it only shows the far left end, and the far right end of it. The name of this Pivot tab below is "Aging Inv".

Thanks for help!

-->-->

 

[ExcelAtEverything]

Took me a while to do a bunch of trial & error, but this seems to work perfectly.
=GETPIVOTDATA("[Measures].[Sum of Inventory Value]",'Aging Inv'!$B$3,"[Current Inventory Report].[Org #]","[Current Inventory Report].[Org #].&[" & [@[Org '#]] & "]"). This was derived from an earlier answerI received on a similar post which mart37 gave me the answer. I just made some adjustments and fit it into this.

Not sure what to do in this case. Feels weird marking myself as having come up with the answer. Mart37 deserves the credit even though he hasn't responded yet.

 

[smozgur]

Not sure what to do in this case. Feels weird marking myself as having come up with the answer.

If you have an answer for the question and post it in your question, then you can surely mark it as the solution as you also did for the other two questions. The idea is helping future readers to indicate that this title has a working solution.

 

[ExcelAtEverything]

Thanks. Yeah I figured as much. Just seemed weird at first. Thx