Calculating a Grand Total for a Column

You can calculate a grand total for any numeric data column and specify the original total value with a new type of function. For example, by default the totals for a column are sums of the values in those columns. But you can change the totals to averages instead of sums. These Results/Table section functions include:

Data Function	Returns the:
Sum	Sum of all underlying values.
Average	Average of all underlying values.
Maximum	Highest of underlying values.
Minimum	Lowest of underlying values
Count	Number of underlying values.

To apply a grand total to a column:

Select the column and choose Grand Total on the shortcut menu.
A submenu showing all available total functions is displayed.
Select a total function.
The grand total is displayed in a new row at the bottom of the last page in the selected column.

To remove all grand totals:

Select a column to which a grand total was applied and choose Grand Total on the shortcut menu.
A submenu showing all available total functions is displayed.
Select Delete All.

To remove a selected grand total:

Select the row to which a grand total was applied and choose Grand Total on the shortcut menu.
A submenu showing all available total functions is displayed.
Select Delete.