Home >

Design Views and Analyze Data > Advanced Analysis > Totals > Grand Totals > Grand Totals and Aggregations

When you turn on grand totals, the initial values are computing using the current aggregation for the fields in the view. In this case, totals are based on the underlying data rather than the data in the view.

For example, if you are totaling the SUM(Profit) for several products, the grand total will be the sum of the sums of profit. For aggregations such as SUM, you can easily verify the grand total because a summation of a group of sums is still a summation. However, be aware that your results may be unexpected when using other aggregations, especially custom aggregations. For details, See Configuring Grand Totals. You can verify any calculation such as an aggregation or a grand total by viewing the underlying disaggregated data.

The following table summarizes the standard aggregations and the grand totals that are calculated by default when, from the Analysis menu, Totals > Total All Using is set to the default value Automatic.

Aggregation | Calculation Description |
---|---|

Sum | Shows the sum of the values shown in the row or column. |

Average | Shows the average of the values shown in the row or column. |

Median | Shows the median for the values shown in the row or column. |

Count; Count Distinct |
Shows how many values or distinct values are displayed in the rows and columns in the view. |

Minimum | Shows the minimum value shown in the row or column. |

Maximum | Shows the maximum value shown in the row or column. |

Percentile | Shows the average percentile for all values shown in the row or column. |

Standard Deviation | The grand total using standard deviation is the standard deviation of the values shown in the row or column. |

Variance | The grand total using variance is not the variance of the rows and columns in which they reside but rather of the underlying data behind the row or column. |