Calculated Field

The pivot grid inserts a new calculated field based on the existing calculated items using the calculated field window. This option is available as a menu item in the grouping bar context menu.

Inserting a new calculated field in pivot grid

To insert a new calculated field, open the calculated field window using the grouping bar context menu. Then, define a Name for the new calculated field.

Defining Name for the Calculated Field

Defining Name for the Calculated Field

Note that, the Formula can be entered by inserting calculation fields through the Fields section. For inserting numerical operator, you can use the formula pop-up as shown in the following screenshot.

Entering Formula for the Calculated Field

Entering Formula for the Calculated Field

Click Add to add the calculated field and OK to populate the pivot grid control.

PivotGrid with newly added Calculated Field

PivotGrid with newly added Calculated Field