Was this page helpful?
Yes No
Have a comment? Please leave it here.Thanks for your feedback!

Home > 

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

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 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.