2007 Excel - GETPIVOTDATA

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

Elizabeth

I want to create a formula that should be easy but can't get it to work for
some reason. I have 3 cells within a pivot table that I want to add, then
divide by a different cell. This is what I am trying to use:

=GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New
Business")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business
BOR")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business: one
time revenue for special project")/GETPIVOTDATA("AnnualizedCommission",$A$3)

I get a calculation, but it is wrong. Basically, my answer should be 62%
but I am getting 413%. I've tried every function I can think of - can anyone
help? Thanks!
 
Elizabeth said:
I want to create a formula that should be easy but can't get it to work for
some reason. I have 3 cells within a pivot table that I want to add, then
divide by a different cell. This is what I am trying to use:

=GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New
Business")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business
BOR")+GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business: one
time revenue for special project")/GETPIVOTDATA("AnnualizedCommission",$A$3)

I get a calculation, but it is wrong. Basically, my answer should be 62%
but I am getting 413%. I've tried every function I can think of - can anyone
help? Thanks!
Click to expand...


Maybe this:

=(GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business BOR")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status",
"New Business: one time revenue for special project"))/
GETPIVOTDATA("AnnualizedCommission",$A$3)
 
Glen, thank you soooo much! That did the trick!

Glenn said:
Maybe this:

=(GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New Business")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status","New business BOR")+
GETPIVOTDATA("AnnualizedCommission",$A$3,"Status",
"New Business: one time revenue for special project"))/
GETPIVOTDATA("AnnualizedCommission",$A$3)
.
Click to expand...
 
Back
Top