Formula fields in Pivot Tables?

P

Pat Dools

Hello,
I am trying to make a formula field that will add up 'Premium $' when my
'Status' field has a certain value and show that sum in the Data Area of 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 Pivot Table source data. But, when I add the formula field to
the pivot table, I get '$0.00' for the value.
I would like to be able to evaluate the 'Pipeline_Status' field for
different values, and put the sum of the records that contain those values
side-by-side in the Data Area of the pivot table report. What am I doing
incorrectly here?
 
S

Shane Devenshire

Hi,

I think it would help us to see some sample data. Calculated Items and
Fields can be very tricky.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing Formula fields in Pivot Tables? 3
Formula fields in Pivot table reports? 2
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table Calculated field error 1
Changing Default Function in Pivot Tables 1
Pivot Table Formula Problem 1
Using text values in Pivot Tables 5
Excel Pivot Tables 1

Top