GetPivotData Returns Ref Error On Cell Refs

Hi all,

Using Excel 2016.
Pivot Report Layout is Tabular
Item labels are repeating

I clicked on a cell, type "=" and clicked on a value in PivotTable.
Returned a GetPivotData formulas like :

=GETPIVOTDATA("JobComplete",Pivot!$D$11,"WorkType","PM","Site","Control","FY","FY2012","FP","OCT","Market","NorCal","AssetDescription","400 to 500")

I tried changing the references to cell references, but I receive a Ref error

=GETPIVOTDATA("JobComplete",Pivot!$D$11,"WorkType",C3,"Site",D3,"FY",F3,"FP",G3,"Market",B3,"AssetDescription",E3)

Any thoughts?
thx

Got it. I have to test for possibility of all FY/FP combinations. IF it does not exist in the Pivot, a Ref errors is retuned. I added an IFERROR() wrapper to handle it.

thx

Hi goss,

Is this solved?

If not, can you post your example?

Thanks