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.      When you are defining the condition, choose All Characteristics in Drilldown Independent, under Characteristic Assignment.

       2.      Enter the following condition row:

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 overall 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 overall result to represent the sum of the Top 5 products, you need to use the function Calculate Results as Summation:

In the context menu, choose Calculate Results as Summation. For more information, see Calculate Results As....

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