View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elizabeth[_2_] Elizabeth[_2_] is offline
external usenet poster
 
Posts: 1
Default 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!