You can quickly add custom member groupings into your reporting. These calculations are then available for selection from the member selector across all grids and formulas sharing the same cube connection within the workbook.
You can quickly add custom member groupings into your reporting. These calculations are then available for selection from the member selector across all grids and formulas sharing the same cube connection within the workbook.
To add a grouping:
- Open the grid designer and in the member selector, select the members you want to group.
Hold Ctrl to select more than one member. - Right-click and select Group Members.
- Define a name for the grouping, the type of aggregate to be applied, and the parent member the calculation will appear under.
The calculation appears in the member selector under the defined parent with the defined name. This can then be selected to be used as part of the grid.
If you want to change or delete the calculation, select the Custom Calculations tab on the Anaplan XL ribbon. This shows all user defined calculations in the workbook, which can then be edited or deleted.
