Ranked List Condition: Top 5 Products 

You have the following sample query:

You now only want to see the five products with the highest revenue. Define the following condition:

       1.      In the dialog box, choose Defining a Condition in the Evaluation of Conditions Below for all Characteristics in Drilldown Independently.

       2.      In the field Display all Values for which at least one of the following conditions are valid, enter the following condition line:

Choose the key figure Net Revenue, the operator Top N and enter 5 as the value.

The query now displays the five products with the highest revenue:

Rule 1: No Influence on Results Rows

Note here that the total result is not the sum of the Top 5 products. This is because, by default, the total is calculated without taking the conditions into account.

If you apply conditions to a query, you are not changing any numbers. Instead, you are just hiding the numbers that are not relevant for you. Conditions have no effect on the displayed values of the results rows. The results row of a query with an active condition always corresponds to the results row of the query without a condition.

If you want to have the total result to represent the sum of the Top 5 products, you need to use the function Calculate Results as Sum:

In the context menu, choose Calculate Results as Sum. You can find additional information under Calculate Results As....

Top 5 products with local calculation of the results row as a sum: