Insert Calculated Item Dialog
- 2 minutes to read
End-users can invoke this dialog by doing the following:
- Selecting a cell in the row or column field to which the calculated item should be added;
Clicking the Calculated Item… item in the Fields, Items, & Sets drop-down menu. Add the Calculations ribbon group to enable this menu (refer to the Create a Simple Spreadsheet Application topic for details on how to provide your application with a Ribbon UI).
The calculated item’s formula can contain constants and references to other items in the same field to which the calculated item belongs. End-users can select the desired item in the Items list and click the Insert Item button to include the item reference to the formula.
Clicking the Add button adds the calculated item to the target PivotTable field.
End-users can modify the existing calculated item by selecting the desired item in the Name drop-down list and changing its formula. The calculated item’s name cannot be modified from this dialog.
Clicking the Delete button removes the selected calculated item.