IF formulas in Excel 2003 Pivot Tables?
 

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