| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getpivotdata in excel 2007 | Charts and Charting in Excel | |||
| Excel 2007 GetPivotData Function | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA in Excel 2007 | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA in Excel 2007 | Excel Worksheet Functions | |||
| GETPIVOTDATA in Excel 2007 | Excel Worksheet Functions | |||
![Elizabeth[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
