Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Field in Pivot Table
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. pamarty wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
calculated field in a pivot table? | Excel Discussion (Misc queries) | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Pivot table page field switch to (all) if my criteria is not avail | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |