| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Subtotals"
(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…') |
(Added categories) |
||
| Line 4: | Line 4: | ||
To remove the Subtotal, select the {{Menu|XLCubed|Apply|Show Subtotals|None}} menu item. | To remove the Subtotal, select the {{Menu|XLCubed|Apply|Show Subtotals|None}} menu item. | ||
| + | |||
| + | [[Category:Grid Reporting]] | ||
| + | [[Category:OLAP Operations]] | ||
Revision as of 12:57, 8 October 2010
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.
