Referencing Pivot Table Data

[Zee996]

I have Pivot Tables which will expand & retract over time depending on the current information loaded into them.
And I need help creating a formula that will reference the data from the pivot table to a specific format(See Screenshot).

I have tried Index and Match but at some point, I am getting an error because of the multiple criteria(Months and Weeks). Is there any other way to do it?

Thank you!

 

[shift-del]

Hi

Microsoft invented GETPIVOTDATA() for this.

GETPIVOTDATA function - Microsoft Support

Syntax: GETPIVOTDATA(data_field, pivot_table, [field1, item1, field2, item2], ...)

support.microsoft.com