Subtotal by hierarchy is an option in grid-based reports where a cross-join has been used. Subtotals can use sum, avg, min, or max functions.
To add a subtotal:
- Select a cell in the grid containing a member of the hierarchy you want to add the subtotal to.
- In the Anaplan XL grid ribbon, select the type of calculation to apply. This adds a new row or column next to each member of the selected hierarchy.
- To remove the subtotal, select the Anaplan XL > Apply > Show Subtotals > None menu item.
