Setting Up Totals: Data Area

Showing of total values in rows or in columns based on source data can be set up for a data area.

NOTE. Totals by levels and dimensions are set up similarly to the totals by rows and columns.

To set up total values for rows or columns, go to the Totals tab of the Data Area Properties dialog box. The dialog box looks as follows:

If the Totals Based on Hierarchy checkbox is selected, totals by all child elements are calculated.

If the Totals Based on Level checkbox is selected, totals by all displayed level elements are calculated.

The following parameters of total values calculation can be set up for each area:

Select the required method in the Totals Calculation Method drop-down list for each area:

None. No aggregation is executed.
Sum. Values are summed up.
Minimum. The minimum value is selected.
Maximum. The maximum value is selected.
Number of Non-empty. The number of non-empty values is determined.
Number of Empty. The number of empty values is determined.
Number of All Children. The number of child elements is determined.
Arithmetic Mean. The mean value is estimated accounting for empty values.
Actual Mean. The mean value is estimated ignoring empty values.
First Actual. The first existing (actual) value is taken.
Last Actual. The last existing (actual) value is taken.
Root-mean-square Deviation based on Sample. Root-mean-square deviation is defined for row by sample data.
Median. Series median is defined.
Root-mean-square Deviation. Determines series root-mean-square deviation based on the entire population.
Grand Total. This method is shown if server aggregation of cube facts dimension is set up in the data source. On selecting this option, the method defined for server aggregation of fact dimension is used. If the element is not linked to a standard fact, or the aggregation method is not defined, the totals are calculated as a sum of values. Server aggregation for a cube can be set up using the Fore language.

The Totals Based on Hierarchy and Totals Based on Levels groups include the Show Aggregate Other checkbox. When the checkbox is selected, totals are calculated for dimension elements not included into selection. See below examples of a table containing hierarchy-based totals without showing the Other aggregate (top) and with showing the Other aggregate (bottom):

If data area has two or more dimensions in rows or in columns, totals are calculated by levels taking into account data of child elements.

Formatting of total cells is set up using a standard component for header and data.

See an example of data area with the totals based on hierarchy (top data area) and based on level (bottom data area):