Calculation of table totals by columns and/or by rows and setting up their displaying are executed in the Row Totals/Column Totals group of parameters.
To open the group of parameters
Settings in the Row Totals and the Column Totals parameters are identical:
Available settings:
Select on or several required total types in the Total Types drop-down list:
Sum.
Arithmetic mean.
Minimum.
Maximum.
Mode.
Median.
Variance.
Root-mean-square deviation.
Skewness.
Kurtosis.
Range.
Variation coefficient.
Sum of squares.
First-order autocorrelation.
Upper decile.
Upper quartile.
Lower quartile.
Lower decile.
Number of empty cells.
Number of non-empty cells.
Total values of the selected types will be automatically calculated. To reset the selected types and hide totals, click the Clear button.
Examples of row and column totals
After total types are selected, set their calculation options on the Calculation Options tab:
Treat Empty as Zeros. When the checkbox is selected, empty values in cells will be treated with zeroes. This is important, for example, on calculating average values. The checkbox is deselected by default.
NOTE. Selecting the checkbox does not affect the result of calculating totals with the Number of Empty Cells and the Number of Non-Empty Cells types, and the result of calculating the Average basic aggregate in the status bar.
Ignore Values in Nodes. When the checkbox is selected, values of parent elements of the hierarchy are ignored. The checkbox is deselected by default.
NOTE. The parameter is recommended to be used if data was aggregated into parent elements from all child elements.
Grand Total. When the checkbox is selected, grand totals calculated by all table columns/rows are displayed. The checkbox is selected by default.
NOTE. If the grand total matches the subtotal by hierarchy/levels, it is recommended to disable displaying of grand total to avoid duplicated data.
Subtotal. When the checkbox is selected, totals calculated by hierarchy and/or levels are displayed, depending on the state of the By Hierarchy and the By Levels checkboxes, and names of totals display names of hierarchy parent elements or names of levels, respectively. The checkboxes are selected by default.
The Subtotal, the By Hierarchy and By Levels checkboxes are relevant if elements of hierarchical dimension of different levels of hierarchy are displayed in the table.
Output Before Data. When the checkbox is selected, totals are displayed before cells with data. The checkbox is deselected by default.
Calculate for One Element. When the checkbox is selected, totals are additionally calculated for elements by each level and for elements containing one column or rows. The checkbox is deselected by default.
Examples of displaying totals when different calculation options are used
If a table displays hierarchical dimension elements from different hierarchy levels, set parameters on the Output String tab to output grand total and/or hierarchy total to the parent element string:
Grand Total. When the checkbox is selected, the grand total is output to the parent element string. The checkbox is deselected by default.
Totals by Hierarchy. When the checkbox is selected, totals by hierarchy are output to the parent element string. The checkbox is deselected by default.
Total Type. In the drop-down list select one of the total types applied to the table. The parameter is available if the Grand Total checkbox and/or the Totals by Hierarchy checkbox is selected.
Element Name. In the drop-down list select the type of displaying parent element name:
Source Element. It displays source element name.
Total Method. It displays total method name.
Combined. Default value. It displays name of the source element and total method.
The parameter is available if the Grand Total checkbox and/or the Totals by Hierarchy checkbox is selected.
Separator. The box is used to set separator between element and total method names. The "," character is set as a default separator. The parameter is available if the Grand Total checkbox and/or the Totals by Hierarchy checkbox is selected, and the Combined name type is selected.
See also: