Create calculations for named sets

If a dimension includes named sets, you can create a calculation that is based on the set members.

To launch the calculation editor in a view, do the following steps:
  1. Right-click a row or column label, or the rows row selector or columns handle column selector.
  2. Click Subset calculation.

    The calculation options are the same as in the Summarize all calculation. The Aggregate option is available only on a server that supports aggregates.

    If you created the subset calculation for specific rows or columns, the calculation is added in the grid after the related row or column. If you created the subset calculation from the rows or columns handle, the calculation is added as the last row or column.

Subset calculation editor.

For more information, see Add a subset calculation to a view.