Create calculations for named sets
If a dimension includes named sets, you can create a calculation that is based on the set members.
- Right-click a row or column label, or the rows or columns handle .
- 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.
For more information, see Add a subset calculation to a view.