Leading the way in Microsoft Office Development

What is a Calculated Item ?

You can create new items that can appear in your fields that are not part of the original source data.

A calculated field contains user-created formula to determine the value of the item in a particular field.

(PivotTable > Formulas > Calculated Item).

You create a calculated item by adding a new item to a field and then defining a formula that calculates the individual values for the item.

Creating a Calculated Item

Notice that the caption of the dialog box identifies the field you are going to insert the item into.

Removing a Calculated Item

Things to Remember