Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I am trying to get the sum of premium for records that have a certain value in a field in my source data to show in a pivot table report. For example, I have this formula field: = IF(Pipeline_Status= "In Pipeline",POL_PREMIUM,0) where 'Pipeline_Status' is a text field and 'POL_PREMIUM' is a currency field in my source data. When I add the formula field to my Pivot Table, I simply get '$0.00' in the Pivot table for this formula field. I would like to evaluate for different 'Pipeline_Status' values and show them side-by-side in the Data Area of the Pivot Table report. -- Pat Dools |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Excel 2003 - pivot tables | Excel Discussion (Misc queries) | |||
Pivot tables in Excel 2003 and 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 Pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Excel 2003 | Excel Discussion (Misc queries) | |||
Pivot Tables - Using Excel 2003 & Windows XP Pro... | Excel Discussion (Misc queries) |