Prerequisites
You can calculate a maximum and minimum for one or more columns. Maximums and minimums can only be calculated for Key Figures.
If a maximum and minimum is calculated using heterogeneous units, such as kilograms and liters or several currencies, a maximum and minimum is calculated for each unit.
Procedure
Calculating Maximum / Minimum
- Choose ® Maximum/Minimum.
Result
Maximums and minimums are usually displayed with a yellow background in a separate line underneath the entries. If a maximum and minimum is calculated using heterogeneous units, such as kilograms and liters or several currencies, a maximum and minimum is calculated for each unit (a line with maximum / minimum is displayed for each unit).
Depending on the list, the maximum / minimum may be displayed above the lines.
See:
Calculating and Deleting Subtotals
Deleting Maximum/Minimum
To delete a maximum or minimum, proceed as follows:
- Choose ® Maximum/Minimum.
Alternative procedure in full screen mode
In full screen mode, you can also activate the function using the menus.
To calculate a maximum/minimum, proceed as follows:
- Choose Edit ® Calculate ® Maximum/Minimum.
To delete a maximum / minimum, proceed as follows:
No comments:
Post a Comment