Add an asymmetric calculation to a view

You can create calculations that apply to nested dimension sets on rows or columns in a view. Known as asymmetric calculations, these calculations are applied to specific selected members and are not common to all nested sets for the dimension.

About this task

An asymmetric calculation can be applied within a single nested set or span multiple nested sets of the same dimension. Note, an asymmetric calculation is calculated by using the specific members that you select in the context of a nested dimension.

Procedure

  1. Click the Target selection icon in the toolbar or press F7.
    You are now in target selection mode.
  2. Select the members that you want to be included in the calculation. Use Ctrl+click to select multiple nonadjacent members, use SHIFT+click to select multiple adjacent members. The asymmetric calculation is inserted next to the last member you select.
  3. Right-click a selected member, then click Calculation options.
    Creating an asymmetric calculation
  4. Enter a descriptive name for the calculation.
    If you create a calculation without entering a descriptive name, the calculation is automatically assigned a name that reflects the calculation type you choose, with references to the members included in the calculation. For example, Golf Accessories + Putters or median (Irons, Putters, Woods).
  5. Select the calculation that you want to apply. See Member calculations for more details on the calculations that are available.
  6. Click OK.
  7. To remove a calculation, right-click the calculation label in the view, then click Remove.