B
Bazy2k
Morning guys.
I have a pivot table which looks like this...
COST CENTRE
NUMBER VET IT OTHER
7800 750.00 100.00 76.00
In order for me to obtain the sum of the VET and IT cost centre amounts only
for the account code 7800 i am currently using the following formula:
=GETPIVOTDATA("Sum Of
GoodsValueInBase",'PivotTab'!$A$3,"Number","7800","CostCentre","VET") +
GETPIVOTDATA("Sum Of
GoodsValueInBase",'PivotTab'!$A$3,"Number","7800","CostCentre","IT")
So basically i am picking off the two entries from the pivot table
seperately and adding them together.
Is there any way i can use the getpivotdata function to look up them both
and add them together (the formula bar runs out of room if i am using too
many accountnumbers and cost centres, so i am looking for a shorter formula)
Something like
=GETPIVOTDATA("Sum Of
GoodsValueInBase",'PivotTab'!$A$3,"AccountNumber","7800","AccountCostCentre","VET" & "AccountCostCentre", "IT")
Thanks in advance
Bazy2k
I have a pivot table which looks like this...
COST CENTRE
NUMBER VET IT OTHER
7800 750.00 100.00 76.00
In order for me to obtain the sum of the VET and IT cost centre amounts only
for the account code 7800 i am currently using the following formula:
=GETPIVOTDATA("Sum Of
GoodsValueInBase",'PivotTab'!$A$3,"Number","7800","CostCentre","VET") +
GETPIVOTDATA("Sum Of
GoodsValueInBase",'PivotTab'!$A$3,"Number","7800","CostCentre","IT")
So basically i am picking off the two entries from the pivot table
seperately and adding them together.
Is there any way i can use the getpivotdata function to look up them both
and add them together (the formula bar runs out of room if i am using too
many accountnumbers and cost centres, so i am looking for a shorter formula)
Something like
=GETPIVOTDATA("Sum Of
GoodsValueInBase",'PivotTab'!$A$3,"AccountNumber","7800","AccountCostCentre","VET" & "AccountCostCentre", "IT")
Thanks in advance
Bazy2k