Show TOC

To define the calculation of totals Locate this document in the navigation structure

Context

The default setting is to display totals according to the definition in the query. You can calculate with these values to display another result, for example the highest value for an area.

Procedure

  1. Select a measure heading in the crosstab.
  2. Choose Start of the navigation path Totals Next navigation step Calculate Totals As Next navigation step [Option] End of the navigation path.
    The following options are available:
    Option Description
    Minimum The smallest value for the corresponding area is displayed as the result.
    Maximum The highest value for the corresponding area is displayed as the result.
    Sum The total of all values for the corresponding area is displayed as the result.
    Sum of Rounded Values If you have set a scaling factor, it is useful to calculate the totals of rounded values locally since the totals can differ considerably (in particular with high scaling factors).
    Total Number of Detailed Values The number of values for the corresponding area is displayed as the result.
    Total Number of Detailed Values that are Not Zero, Null or Error The number of values for the corresponding area, excluding zeros, is displayed as the result.
    Standard Deviation The deviation of the values from its mean is displayed as the result. The more spread out the data is, the higher the deviation. Standard deviation is calculated as the square root of variance.

    For example, the mean of the following two is the same: 15, 15, 15, 14, 16 and 2, 7, 14, 22, 30. However, the second is clearly more spread out.

    Average The average (total divided by total number of values) of all values for the corresponding area is displayed as the result.
    Average of All Detailed Values that are Not Zero, Null or Error The average (total divided by number) of all values for the corresponding area is displayed as the result, with the exception of zeros, meaning that values equal to zero are not counted.
    Median

    The system sorts the values internally by size and displays the mean value from the list as the result.

    For example, if there are five values in the list, the third value is displayed as the result. If the list has an even number of values (for example six), the system adds the two values in the middle of the list together (in this case, the third and fourth values) and divides the result by two. The resulting value is displayed as the result.

    Median of Detailed Values that are Not Zero, Null or Error

    Excluding the values that are equal to zero, the system sorts the values internally by size and displays the mean value from the list as the result.

    Variance

    The variance is calculated as the square of the standard deviation and displayed as the result.

    Hide The result is not displayed.
    Default With this setting, the results provided by the query are displayed.

Results

The totals are calculated according to your definition.