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.