Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA function | Excel Worksheet Functions | |||
Vlookup Syntax Error | New Users to Excel | |||
Generate GetPivotData | Setting up and Configuration of Excel | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions | |||
GetPivotData | Excel Worksheet Functions |