Calculated Field in Pivot Table

P

pamarty

Could someone help me with the calculated field in Pivot table. I am
using a huge spreadsheet with finiancial data which has multiple rows
and columns. Two of the rows are Balance and Coupon. I am trying to
create a pivot table with a calculated field that should use formula
∑ (balance*coupon).

When I specify the formula as =Balance* Coupon is the calculated field.
The values displayed are not in accordance with ∑ (balance*coupon).
It seems that the formula calculates ∑ Balance * ∑ Coupon.

Any suggestions?

Thanks,
Hema
 
D

Debra Dalgleish

If you want the individual records multiplied, then summed, you can add
a field to the source data, to calculate the product. Then, add that
field to the pivot table.
 

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

Dealing with a Pivot Table (when I don't want to) 0
First row where a cell is zero 2
Data Grand Total in Pivot Table Row Area 1
Excel 2007 - Pivot Table and Calculated fields? 1
Running Total, Opening & Closing Acct Balance in Cash Book 1
Subtotal percents in pivot table 1
Pivot Table - Duplicated Data on Row Labels 0
Pivot Table – Duplicated Data on Row Labels 2

Top