2007 Excel - GETPIVOTDATA
 

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,"St atus","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!

2007 Excel - GETPIVOTDATA
 

Elizabeth wrote:
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,"St atus","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!


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)

2007 Excel - GETPIVOTDATA
 

Glen, thank you soooo much! That did the trick!

"Glenn" wrote:

Elizabeth wrote:
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,"St atus","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!


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)
.