Show TOC

 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".

Note Note

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

End of the note.

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

Start of the navigation path Edit Next navigation step Ranking list Next navigation step Top n End of the navigation path

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 %

Start of the navigation path Edit Next navigation step Ranking list Next navigation step Top % End of the navigation path

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

Start of the navigation path Edit Next navigation step Ranking list Next navigation step Last n End of the navigation path

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 %

Start of the navigation path Edit Next navigation step Ranking list Next navigation step Last n End of the navigation path

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.

Note Note

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

End of the note.