In the last post on Excel PivotTable, we have seen how to create a PivotTable. Here we will see how to add a new field called calculated fields. Calculated field in PivotTable can be created by performing simple arithmetic calculation on existing field.
Steps to Create a Calculated Field in Excel PivotTable:
- Click any Field in the pivot Table. The PivotTable Tools become available.
- Click on ‘Options’ and then Click on Field list( In Excel 2010, it is ‘Fields, Items,&Sets.
- Click on Formulas. A Menu appears.
- Click calculated Field. The insert Calaculated Field dialog box appears.
- Type the name for the new field
- Double click an existing field to use in defining the field
- Type the operator and the value or the filed such as *1.5
- Click on Ok.
Values of the calculated field fill the data area and the calculated field appears at the end of the field list.