getpivotdata syntax
 

I'm struggling with getting the right sytax on a getpivotdata formula because
of some spaces: =getpivotdata(beasley!$b$5,"total classroom 3456") where
Classroom 3456 is a pivot table field. I looked in this discussion group and
found something very similar but couldn't get it to work. I'm now at
=getpivotdata(beasley!$b$5,"total "&"classroom "&"3456") but that's giving me
#N/A. I also tried =GETPIVOTDATA(beasley!$B$5,"total 'CLASSROOM 3456'")
which gives me #REF. Thanks in advance for any suggestions.

The syntax of the GETPIVOTDATA

"neoschenker" wrote:

I'm struggling with getting the right sytax on a getpivotdata formula because
of some spaces: =getpivotdata(beasley!$b$5,"total classroom 3456") where
Classroom 3456 is a pivot table field. I looked in this discussion group and
found something very similar but couldn't get it to work. I'm now at
=getpivotdata(beasley!$b$5,"total "&"classroom "&"3456") but that's giving me
#N/A. I also tried =GETPIVOTDATA(beasley!$B$5,"total 'CLASSROOM 3456'")
which gives me #REF. Thanks in advance for any suggestions.

Sorry about the false start.
GETPIVOTDATA has a different syntax for versions 2002 and later than for
earlier versions, so it's possible that is part of the problem.
You might check out this web page for a good overivew of this function:
http://www.contextures.com/xlPivot06.html

tj

"neoschenker" wrote:

I'm struggling with getting the right sytax on a getpivotdata formula because
of some spaces: =getpivotdata(beasley!$b$5,"total classroom 3456") where
Classroom 3456 is a pivot table field. I looked in this discussion group and
found something very similar but couldn't get it to work. I'm now at
=getpivotdata(beasley!$b$5,"total "&"classroom "&"3456") but that's giving me
#N/A. I also tried =GETPIVOTDATA(beasley!$B$5,"total 'CLASSROOM 3456'")
which gives me #REF. Thanks in advance for any suggestions.