I am working with a file that has two sheets. The first sheet has a PivotTable that pulls in monthly spend projections on purchase order #s from an external data source. The second sheet needs to pull in the data from the PivotTable, however I keep getting a #REF error using the formula below:
=GETPIVOTDATA("[Measures].[Total Client Side Est Billings]",'Spend Projections'!$A$7,"[Project Financial Model].[Dates.Month Year]",B$1,"[Agreement Funding Model].[Agreements.External Agreement Number]",$A2)
Would appreciate any help. Thank you!