Inserting a Grand Totals

Use the Insert Grand Total dialog box to apply a grand total to a column. A grand total on a numeric column applies a default "sum" function. However, each column can have a number of grand totals, each with a different aggregate function (such as minimum, maximum, average, and so on) applied to it.

To apply a grand total to a column using a data function:

Select a column and choose Results, then Grand Total.
The Insert Grand Total dialog box is displayed.
Select a data function from the Grand Total Function drop-down list.
Select one or more columns to be totalled from the Add Grand Total To list and click OK.
The total and any subtotals in the column are computed to reflect the new data function.

Table 29. Insert Grand Total

Option	Description
Grand total function	The data function to apply. Available data functions include: Sum—Returns the sum of underlying values. Average—Returns the average of underlying values. Minimum—Returns the lowest of underlying values. Maximum—Returns the highest of underlying values. Count—Returns the number of underlying values. Other—Allows you to create a custom function using JavaScript. SeeWorking with Custom Functions for more information.
Add grand total to	The column or columns on which to apply the grand total.

Option

Description

Grand total function

The data function to apply. Available data functions include:

Sum—Returns the sum of underlying values.
Average—Returns the average of underlying values.
Minimum—Returns the lowest of underlying values.
Maximum—Returns the highest of underlying values.
Count—Returns the number of underlying values.
Other—Allows you to create a custom function using JavaScript. SeeWorking with Custom Functions for more information.

Add grand total to

The column or columns on which to apply the grand total.