Subtotals

From XLCubedWiki

Jump to: navigation, search

Subtotalling by hierarchy is an option in Grid based reports where a crossjoin has been used. Subtotalling can use any one of the Sum, Avg, Min or Max functions.

To add a Subtotal, right-click on one of the members of the hierarchy you would like to add the Subtotal to, and choose the function you require under the XLCubed > Apply > Show Subtotals menu:
SubtotalMenu.png

To remove the Subtotal, select the XLCubed > Apply > Show Subtotals > None menu item.

Personal tools
Namespaces
Variants
Actions
Follow XLCubed on Twitter XLCubed on LinkedIn Download

Navigation
Toolbox