GetPivotData - Can't retrieve the subtotals.
In the Excel97 help example, how would I get "March Total Beverages"?
In my PT, it says Sum instead of Total, but I have tried every combination of the column heading and subtotal heading and the words "sum" "sum of" and "total", but I can't retrieve the subtotals. It's driving me nuts.
ex.
WK10
SYS10 MACH1 5
MACH2 10
SYS10 Sum 15
SYS20 MACH1 50
MACH2 100
SYS20 Sum 150
Grand Total 165
How to I get
"SYS10 Sum WK10" = 15
"SYS20 Sum WK10" = 150
I get either #N/A! or #REF!, depending on what combinations I try.
Thanks in advance,
Brian
This message was edited by Brian on 2002-05-02 18:50
In the Excel97 help example, how would I get "March Total Beverages"?
In my PT, it says Sum instead of Total, but I have tried every combination of the column heading and subtotal heading and the words "sum" "sum of" and "total", but I can't retrieve the subtotals. It's driving me nuts.
ex.
WK10
SYS10 MACH1 5
MACH2 10
SYS10 Sum 15
SYS20 MACH1 50
MACH2 100
SYS20 Sum 150
Grand Total 165
How to I get
"SYS10 Sum WK10" = 15
"SYS20 Sum WK10" = 150
I get either #N/A! or #REF!, depending on what combinations I try.
Thanks in advance,
Brian
This message was edited by Brian on 2002-05-02 18:50