Inserting Break Totals

Use the Insert Break Total dialog box to apply a break total to a column. Break totals are typically used in reference to subtotals. Subtotals are generated by a break column. The break column contains the data by which you group (break) your total. A break column contains characters (as opposed to numbers). When you apply a break total, the total automatically sorts data by the break column and concatenates the unique values.

  To apply a break total (subtotal):

  1. Select a column and choose Results, then Break Total.

    The Insert Break Total dialog box is displayed.

  2. Select a break column from the At Every Break drop-down list.

  3. Select a data function from the Break Total Function drop-down list.

  4. Select one or more columns on which to display the break total and click OK.

  To remove a break total:

  1. Highlight a break total row by clicking in the left margin.

    The break total row is highlighted

  2. On the shortcut menu, click Remove Row.

    All break totals associated with the rows are removed from the column.

Table 28. Insert Break Total

Option

Description

At every break in

The column on which to break.

Break 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 break total to

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