GETPIVOTDATA using a reference for field name
 

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.

GETPIVOTDATA using a reference for field name
 

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.

GETPIVOTDATA using a reference for field name
 

Add an empty string to the B20 reference:


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

Rayo K wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

GETPIVOTDATA using a reference for field name
 

Thanks. It actually didn't work, but I decided that I wouldn't need the
references to change so I just typed them in.

"Debra Dalgleish" wrote:

Add an empty string to the B20 reference:


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

Rayo K wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html