Hi

GETPIVOTDATA(data_field,pivot_table,field1,item1,f ield2,item2,...)

In the above format of the GetPivotData I am able to reference all the
Item and Field names but not the Data_Field

Example


Data_field = "Amount" in Cell A3
field1 = "Income" in Cell A2
Item1 = "Account Type" in Cell A1

The Following Works

=getpivotdata("Amount",CashFlow!A7,A1,A2)

But When I try and use a reference for the data_Field Then I get a
#REF!

=getpivotdata(A1,CashFlow!A7,A1,A2)

I tried using INDIRECT() , Enetering "Amount" in cell A1 with the "


Can anyone help.

Thanks

Roger