Creating Subtotals

Use

You can create subtotals in one or more columns in the list that are not value columns. This function is also available for fields that are not in the list.

You can create subtotals in sequential lists for column headers but not, however, for their subordinate rows.

Prerequisites

Before you can create a subtotal, you must have created a total for at least one column (see Displaying and Deleting Sums).

Procedure

Creating Subtotals for One Column

  1. Select the columns for which you require subtotals by clicking on the column header.

  2. Choose Subtotal or Start of the navigation pathEdit Next navigation step SubtotalEnd of the navigation path.

Creating Subtotals for More Than One Column

  1. Choose Subtotal or Start of the navigation pathEdit Next navigation step SubtotalEnd of the navigation path. The dialog box Define Sort Order appears.

  2. The dialog box Define Sort Order shows the fields you can create subtotals on. Fields are also available that are not shown in the list.

  3. You can limit the fields available in the list (field catalog) by choosing a field group that contains the desired fields.

  4. To select fields for subtotaling, select the relevant rows and choose Show Selected Fields (arrow key). The selected fields then appear in the dialog box as sorting fields.

  5. The sequence in which the selected fields are shown in the dialog box determines the sequence in which subtotals are created. To change the sequence of the fields, use the functions Cut and Paste.

  6. Specify whether the rows on which a subtotal is calculated are to be sorted ascending or descending. Also set the indicator for subtotals.

  7. Exit the dialog box with Copy.

Deleting Subtotals

You delete subtotals as follows:

  1. Choose Subtotal or Start of the navigation pathEdit Next navigation step SubtotalEnd of the navigation path. The dialog box Define Sort Order appears.

  2. The dialog box Define Sort Order shows the fields that were selected for subtotaling.

  3. To delete the calculation of subtotals for individual fields, select the corresponding rows in Sorting Fields in the dialog box, and choose Hide Selected Fields (arrow key). The selected fields then appear in the dialog box under Field List.

  4. Exit the dialog box with Copy.