software

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,
HemaIf 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.

pamarty wrote:
gt; Could someone help me with the calculated field in Pivot table. I am
gt; using a huge spreadsheet with finiancial data which has multiple rows
gt; and columns. Two of the rows are Balance and Coupon. I am trying to
gt; create a pivot table with a calculated field that should use formula
gt; ∑ (balance*coupon).
gt;
gt; When I specify the formula as =Balance* Coupon is the calculated field.
gt; The values displayed are not in accordance with ∑ (balance*coupon).
gt; It seems that the formula calculates ∑ Balance * ∑ Coupon.
gt;
gt; Any suggestions?
gt;
gt; Thanks,
gt; Hema
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html