Displaying and Deleting Totals

Prerequisite

You can display totals for one or more columns; this is only possible for Key Figures:

If you total on incompatible units, such as quantities in kilograms and liters or multiple currencies, a total appears for each unit.

Procedure

Displaying Totals

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

Alternatively:

1. 
   
Select one or more columns.
2. Right click one of the selected columns.
3. Choose Total.

Result

The total is usually displayed with a yellow background in an additional row underneath the entries. If you total on incompatible units, such as quantities in kilograms and liters or multiple currencies, a total appears for each unit.

If a total was calculated for a column, a small S is displayed in the column header. For an explanation of the small symbol in front of the total, see Calculating and Deleting Subtotals.

Depending on the list, the totals lines may appear above the entries.

Deleting Totals

To delete totals, proceed as follows:

1. 
   
Select one or more columns for which a total was calculated.
2. Choose ® Total.

Alternatively:

1. 
   
Select one or more columns for which a total was calculated.
2. Right click one of the selected column headers.
3. Choose Total.

Alternative Procedure in Full-Screen Mode

If you are working in full-screen mode, you can also use the menus to execute the function:

To calculate a total, proceed as follows:

1. 
   
Select one or more columns.
2. Choose Edit ® Calculate ® Total.

To delete a total, proceed as follows.

1. 
   
Select one or more columns for which a total was calculated.
2. Choose Edit ® Calculate ® Total.