Calculating a Break Total for a Column

You can add subtotals to the same column by choosing another column of non-numeric data to serve as a “break column.” The break column is used as a reference point to determine where to break the data in the target column. The data in the subtotal column is subtotaled for each distinct range of identical values in the break column.

Once a break total is placed on one column, the break total is applied to all numeric columns.

Like the total functions you can use when adding a grand total, a break total can also consist of different functions. These functions include:

Data Function	Description
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 break total:

Select the column and choose Break Total on the shortcut menu.
A submenu showing all available break total functions is displayed.
Select a total function.
The default total function is “Sum”.
Break totals are displayed in the target column along with the break total function name.

To delete all break totals:

Select the column to which the break total was applied.
Select Break Total on the shortcut menu.
Select Delete All.

To remove a selected break total:

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