I have a pivot table where a feild total is not available -
BN A No 10
Yes 20
CC A No 25
CP A No 15
DIS A Yes 2
DNW A No 15
FTA A No 23
FTAL B No 16
REM A No 17
S B Yes 22
A No 23
Yes 10
N Total
I need to sum the total of A and the total of B. I could use sumif but the table is likely to change shape down the track. Is there anyway to sum it with something like getpivotdata. I can't organise the table to have have a subtotal for A or B
BN A No 10
Yes 20
CC A No 25
CP A No 15
DIS A Yes 2
DNW A No 15
FTA A No 23
FTAL B No 16
REM A No 17
S B Yes 22
A No 23
Yes 10
N Total
I need to sum the total of A and the total of B. I could use sumif but the table is likely to change shape down the track. Is there anyway to sum it with something like getpivotdata. I can't organise the table to have have a subtotal for A or B