Create Groups and Calculated Items

Use a group or calculated item to add new "members" to a column.

For example, you can review how much revenue was generated for mobile devices and compare that number to other product types. You can create a group called Mobile Devices for the Product column that includes Flip Phones and Smart Phones.

  1. Open the analysis for editing.
  2. On the toolbar of the Results tab, click New Group or New Calculated Item.

    The New Group or New Calculated Item dialog is displayed.

  3. Enter a value for Display Label for the group or calculated item when it’s displayed in a view.
  4. In the Values From list, select the column whose values you want to include in the group or calculated item.
  5. If you’re creating a calculated item, select the function for the calculated item.
  6. Move the appropriate column values from the Available area to the Selected area.
  7. For a calculated item with Custom Formula selected as the function, select mathematical operators to include in the function using the toolbar. You can also use these functions: Absolute, Ceiling, Floor, Round, and Sqrt.

    A formula creates a dynamic custom grouping within the view. All measures referenced in a formula must be from the same column and must be present in the results. Formulas can be inserted into, or combined with, other calculated items.

    Instead of specifying a named item for columns, you can specify $n or $-n. Here, n is an integer that indicates the item's row position. If you specify $n, then the measure is taken from the nth row. If you specify $-n, then the measure is taken from the nth to the last row.

    Description of filtering04.gif follows
    Description of the illustration filtering04.gif
  8. Optional: If you’re creating a calculated item, select Remove calculated item members from view.

    Use this box to suppress the display of members that you have included in the calculated item in the view.

  9. Click OK.

    By default, the new group or calculated item is created for all views in the analysis.