Displaying and Deleting Subtotals 

This concept also applies to the calculation of subtotals for averages, minimums, and maximums. The procedure is the same as for subtotals.

Prerequisite

Totals can only be calculated through Key Figures; subtotals can only be calculated through Characteristics.

You have calculated a total for at least one column. Once a total is displayed, the icons and menu options for displaying subtotals are displayed.

Use

The following example shows the use of totals and subtotals. In this example, a total was calculated for the Occupied column.

Then a subtotal is calculated for the No. column (flight number). The total is broken down into several subtotals. A subtotal is the total number of Occupied seats for all rows with the same subtotal criterion (here flight number: No. column). Therefore, the rows between two subtotals have the same value for the subtotal criterion, the identical flight number (No.).

Procedure

Creating Subtotals for One or More Columns

  1. Select one or more columns.
  2. Choose ® Subtotals.

Alternatively:

  1. Select one or more columns.
  2. Right click one of the column headers you selected.
  3. Choose Subtotals.

 

Procedure without column selection

If you choose the subtotals function without having selected a column, you must select the columns for which you want to display subtotals in the Define Sorting / Subtotals dialog box. Proceed as follows:

  1. Select the relevant entry or entries in Available columns.
  2. To add the selected entries to the Sort criteria / Subtotals, choose .

Alternatively:

  1. Select the relevant entry or entries in Available columns.
  2. Click the selected entry or entries again and hold the mouse button. The cursor appears with a small rectangle.
  3. Drag the entries to Sort criteria / Subtotals and drop them there.

To Find terms, choose .

To define a subtotal for a column or columns, click the checkbox under the subtotal symbol. An indicator is set.

For information about how to change the sort type and sequence, see Sorting in Ascending and Descending Order.

To apply your settings, choose .

Result

In the following example, a total was calculated for the Occupancy column and a subtotal for the Airline and Flight no. columns.

On this screen, you see the subtotals levels as well as the non-totals rows. The first subtotal level totals the occupied seats (Occupancy) for the rows with identical flight number (Flight no.), the first subtotal criterion. A small square is displayed next to the first level subtotals.

The second subtotal level adds the first level subtotals that reference the same airline (Airline); this is the second subtotal criterion. Two small squares are displayed next to the second level subtotals. Arrows are used to identify which subtotals belong to which subtotal criteria.

The third level is the totals level, identified by three small squares. This indicates that the total is the total of the top level subtotals.

Displaying and hiding entries and subtotals

To hide or display entries underneath the total or subtotal or to just display the subtotals, use one of the following procedures:

The entries underneath this total or subtotal are hidden. The icon in the subtotal row indicates that the entries underneath a total or subtotal are hidden.

For information about how to hide all the entries and subtotal for a total or subtotal level, see

Defining Drilldown Totals Levels

.

Deleting Subtotals

To delete a subtotal, choose ® Subtotals, without selecting a column. If you selected a column here, you would define a new subtotal for this column.

The Define Sorting / Subtotals dialog box appears.

To delete the subtotal, deselect the relevant checkbox underneath the subtotal icon.

For information about how to change or delete a defined sort, see Sorting in Ascending and Descending Order.

To apply your settings, choose .

Alternative procedure in full-screen mode

In full-screen mode you can call the functions using the menus, in addition to the procedures described above.

  1. Select one or more columns.
  2. Choose Edit ® Subtotals.

To delete subtotals, choose Edit ® Subtotals, without selecting a column