## 4.7.3.3 To define the calculation of totals
## 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 Totals Calculate Totals As [Option] .
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 Val­ ues                                             | 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 De­ tailed Values                                   | The number of values for the corresponding area is displayed as the result.                                                                                                                                                                                                                                                                             |
| Total Number of De­ tailed Values that are Not Zero, Null or Er­ ror | 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.                                                      |
| 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 De­ tailed Values that are Not Zero, Null or Er­ ror  | 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. |
| Option                                                     | Description                                                                                                                                          |
|------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------|
| 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.