| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Subtotals
Revision as of 17:28, 4 October 2010 by Antonio.remedios (talk | contribs) (Created page with 'Subtotalling by hierarchy is an option in Grid based reports where a crossjoin has been used. Subtotalling can use any one of the {{Code|Sum}}, {{Code|Avg}}, {{Code|Min}} or {{Co…')
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:
To remove the Subtotal, select the XLCubed > Apply > Show Subtotals > None menu item.
