Creating a Ranking List

Use

The functions Top n, Top %, Last n and Last % let you create a ranking list based on a single column of the report list. With these functions you can display those rows of the list that have the largest or smallest values in a single column. A subtotal is displayed for these rows, and the rest of the rows are added together and displayed in a row "Remainder".

Each time you define a new display condition, this overwrites any previous condition, so that only one condition can be active at a time.

Activities

Position the cursor on the column for which you want to define the ranking list. The function is available for all the columns of the list.

For more information about changing or deleting ranking lists, see Editing Conditions.

Features

Function

Menu path

Description

Top n

Edit ® Ranking list ® Top n

This function lets you display, for example, the top ten rows in the selected column.

In the dialog box, enter the number of rows you want to see. The system displays the selected rows and a subtotal for those rows, followed by the subtotal for all rows not displayed (row Remainder...). The column for which you defined the condition is highlighted, and the rows are sorted so that the values in that column appear in descending order.

Top %

Edit ® Ranking list ® Top %

This function lets you those rows that add up to a certain percentage of the total in the selected column, starting with the highest value in that column and going down.

In the dialog box, enter the desired percentage in the field %. The system displays the selected rows and a subtotal for those rows, followed by the subtotal for all rows not displayed (row Remainder...). The column for which you defined the condition is highlighted, and the rows are sorted so that the values in that column appear in descending order.

Last n

Edit ® Ranking list ® Last n

This function lets you display, for example, the ten worst rows in the selected column.

In the dialog box, enter the number of rows you want to see. The system displays the selected rows and a subtotal for those rows, followed by the subtotal for all rows not displayed (row Remainder...). The column for which you defined the condition is highlighted, and the rows are sorted so that the values in that column appear in ascending order.

Last %

Edit ® Ranking list ® Last n

This function lets you those rows that add up to a certain percentage of the total in the selected column, starting with the lowest value in that column and going up.

In the dialog box, enter the desired percentage in the field %. The system displays the selected rows and a subtotal for those rows, followed by the subtotal for all rows not displayed (row Remainder...). The column for which you defined the condition is highlighted, and the rows are sorted so that the values in that column appear in ascending order.

The menu paths in your application may differ from those shown above. For details, see the documentation for your application.