Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel 2003 - pivot tables Petka Nemcova Excel Discussion (Misc queries) 0 February 12th 09 10:18 AM
Pivot tables in Excel 2003 and 2007 bakang Excel Discussion (Misc queries) 0 June 26th 08 08:01 AM
Excel 2003 Pivot tables [email protected] Excel Discussion (Misc queries) 0 June 6th 07 08:20 AM
Pivot Tables - Excel 2003 oceanmist Excel Discussion (Misc queries) 1 August 25th 06 04:42 PM
Pivot Tables - Using Excel 2003 & Windows XP Pro... Birmangirl Excel Discussion (Misc queries) 1 June 8th 05 01:32 AM


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"