2007 Excel - GETPIVOTDATA


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!
 
Ad

Advertisements

G

Glenn

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!


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

Advertisements

E

Elizabeth

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top