Calculating and Deleting Subtotals

Use

Caution

The function Calculate Subtotals is not available on all ALV lists directly as a toolbar icon. On some ALV lists it is part of the more powerful Grouping function. You only find the toolbar icon Calculate Subtotals in such lists that are filled from a standard database (in contrast to an In-Memory Database).

For more information, see the section Grouping and Deleting Groupings.

Note

The calculation of means values for Average and Minimum and Maximum behaves in the same way as calculating subtotals.

The following example clarifies the concept of totals and subtotals:

Example

In a table, a total was first calculated for the (Occupied) column.

Then a subtotal is calculated using the (No) column (flight number). The whole total is broken down into multiple subtotals. A subtotal is the total number of Occupied seats for all rows with the same subtotal criterion value (here flight number: No. column).

In other words: The rows between two subtotals have the same attribute as the subtotal criteria - the identical flight number (No.). The total of the occupied places (Occupied) of a flight number represent the subtotal.

Prerequisites

Generally, totals can only be calculated using Key Figures; subtotals can only be calculated using

Characteristics.
You must have calculated a total for at least one column already. Only then do the icons and menu entries for calculating subtotals become active.

Procedure

Creating Subtotals for One or More Columns

Select one or more column(s).
Choose .

Alternatively:

Select one or more column(s).
Right click on one of the column headers you selected.
Choose .

Without Column Selection

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

Select the relevant entries in Available Columns.
To add the selected entries to the Sort Criteria/Subtotals, choose .

Alternatively:

Select the relevant entries in Available Columns.
Click on the selected entry/entries again, but this time hold the mouse button down. The cursor appears with a small rectangle.
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 on the checkbox under the subtotal symbol. A checkmark is set.

For information about how to change the sort type and sequence, see the section Sorting in Ascending and Descending Order.
To apply your settings, choose .

Result

Example

In the example above, a total was calculated for the (Occupancy) column and a subtotal for the (Airline) and (Flight No.) columns.

On this screen, you see the two subtotal levels as well as the non-totals rows. The first subtotal level totals the occupied seats (Occupancy) for the rows with an identical flight number (Flight No.), the first subtotal criterion. A small square next to the subtotals indicates the first level of the subtotal calculation. One small square next to the subtotals indicates the first level of the subtotal calculation.

The second subtotal calculation level adds the subtotals of the first level with the same (Airline); this is the second subtotal criterion. Two small squares next to the subtotals indicate the second level of the subtotal calculation. Arrows are used to identify which subtotals belong to which subtotal criteria.

Three small squares indicate the third level; the totals calculation level. This indicates that the total calculates the top level subtotals.

Displaying and Hiding Entries and Subtotals

To hide or display entries underneath a total or subtotal, or to display just the subtotals, you have two options:

Click on the squares of the relevant subtotal row.
Click on the icon in the relevant subtotal row.

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.

To hide all entries and subtotals for a totals or subtotal level, see the section Setting Drilldown Summation Levels.

Deleting Subtotals

To delete a subtotal, choose Subtotals , without selecting a column. If you were to select a column here, you would define a new subtotal for the column.

The Define Sorting/Subtotals dialog box appears.

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

For information on changing or deleting a sort, see the section Sorting in Ascending and Descending Order.

To apply your settings, choose .

Alternative Procedure in Lists in Fullscreen View

In addition to the previously mentioned procedures, in full-screen mode you can also call the functions using the menu paths.

Select one or more column(s).
Choose Edit Subtotals .

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