Have you tried

=GETPIVOTDATA(indirect(B20),BoardPivot!$A$3,"Shift ",D20,"Year",Calculations!$B$15,"Month",Calculatio ns!$B$14)


"Rayo K" wrote in message
...
Can this be done. I read some posts suggesting it could, but I get a REF
error. Here is my formula:

=GETPIVOTDATA(B20,BoardPivot!$A$3,"Shift",D20,"Yea r",Calculations!$B$15,"Month",Calculations!$B$1 4)

B20 is a cell containing:

=CONCATENATE("M ",A20," KPH")

and A20 is a three digit number.

"M 122 KPH" is an example. This is a calculated field. I am using Windows
XP
and Office 2003.

It works when I enter the field name directly so it is almost certainly
the
source of the error.