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 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:

  1. Select Pivot, then Add Computed Item.

    The Computed Item dialog box is displayed.

  2. 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 a scalar function name, Interactive Reporting numbers the name starting with the number 2.

  3. 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.

    • Click Functions to apply scalar functions using the Functions dialog box.

      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 (‘_’).

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

  5. When the equation is complete, click OK.

    The computed item is added to the data layout and it is displayed as a column in the pivot table.