| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Subtotals"
| Line 10: | Line 10: | ||
Cube mode performs the sub-totaling as part of the query, such that (if the cube calculations support it) any "Average" or "Percent" calculations will remain consistent. | Cube mode performs the sub-totaling as part of the query, such that (if the cube calculations support it) any "Average" or "Percent" calculations will remain consistent. | ||
| + | |||
| + | You can use the "Grid" ribbon to switch between the 2 modes: | ||
| + | |||
| + | [[File:SubtotalRibbon.png|center]] | ||
[[Category:Grid Reporting]] | [[Category:Grid Reporting]] | ||
[[Category:OLAP Operations]] | [[Category:OLAP Operations]] | ||
Revision as of 10:52, 18 September 2013
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.
Cube vs Excel mode
The default is Excel mode, this will use an Excel formula to calculate the totals - this would mean any calculated members will be totaled after the query is run and may not return the number you want (summing the average or percent numbers etc.).
Cube mode performs the sub-totaling as part of the query, such that (if the cube calculations support it) any "Average" or "Percent" calculations will remain consistent.
You can use the "Grid" ribbon to switch between the 2 modes:
