Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table and Calulated Field
In a Pivot table of mine, there is a field called StatusHeader. The values can be Submitted, Closed Out, Paid, Reopened. I need to create a custom calculation now called Net Closed Out, which would be Closed Out - Reopened. Please tell me this can be done within the pivot and I don't have to add a column or modify the source data. ;) Thanks, Brian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table and Calulated Field
Hi Brian
You can create a Calculated Item, by clicking on Status Header, and selecting Formula from the PT Toolbar. Create the Field Net with formula of = Closed Out - Reopened. Once you do this however, you cannot add Status Header to more than one area of the PT. You could add it to the Row area or Column area but choose another field as the item to count in the Data area -- Regards Roger Govier "BerkshireGuy" wrote in message ... In a Pivot table of mine, there is a field called StatusHeader. The values can be Submitted, Closed Out, Paid, Reopened. I need to create a custom calculation now called Net Closed Out, which would be Closed Out - Reopened. Please tell me this can be done within the pivot and I don't have to add a column or modify the source data. ;) Thanks, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum a pivot table field as a calulated field | Excel Discussion (Misc queries) | |||
Pivot Table Field | Excel Discussion (Misc queries) | |||
sum field is zero when using Pivot table | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) |