Calculated Field in Pivot Table
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
|