Adding Computed Items

Use the Add Computed Items command to create new elements in the Pivot section. Computed items enable you to build equations or apply functions to existing data values. Computed items are like normal data items and can be included in pivot tables or reused to compute other data.

To add a computed item:

Choose PivotAddComputed Item.

The Computed Item dialog box appears.

In the Name field, type a name that describes the computation.

The default name is Computed, which is numbered sequentially if there is more than one. If you assign a name to a computed item that is identical to an existing scalar function name, the the name starting with the number 2.

Define the new data item by building an expression in the Definition text box.

Use the operator buttons to insert arithmetic and logical operators at the insertion point.

Click Reference to display the Reference dialog box, and select Request items to place in the equation.

You can also type any portion of the equation or the entire equation directly into the Definition text box using JavaScript. The names are case sensitive, and you must replace spaces in item names with underscores (‘_’).

If necessary, click the Options button to set a new data type for the item.

When the equation is complete, click OK.

The computed item is added to the Outliner and appears as a column in the pivot table.