Ranked List Condition for All Characteristics
in Drilldown Independent: Top 3 Products and Top 3 Sales Channels 
You want to see a query in which the top 3 net revenue generating products are shown. You also want to see the top 3 sales channels for these products.
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 3 as the value.
In the query, put the characteristics Product and Sales Channel into the drilldown. The query now displays the top 3 products and associated top 3 sales channels:
The sum in the total result is calculated locally using the function Calculate Results as Sum in the above example.
In this case, the system first determines the top 3 products and then the top 3 sales channels for each of three products. In total, in addition to the three results rows and the overall results row, nine rows are displayed.
You now want to see the Top 3 sales channels with which you have had the largest net revenue and the top 3 products for each one.
In the context menu, choose the function Exchange Sales Channel with Product. The required query view then appears:
The sum in the total result is calculated locally using the function Calculate Results as Sum in the above example.
First the system determines the top 3 sales channels, and for each of these three sales channels, it determines the top three products.
You can use the same condition for both queries as the condition is defined independently for all characteristics in the drilldown.
Rule 4: Setting All Characteristics in Drilldown Independent
The setting All Characteristics in Drilldown Independent means that each characteristic of the drilldown has a condition (identical) defined for it These conditions are linked with AND according to rule 2 (linking of multiple conditions).
A condition that is defined for all characteristics in the drilldown can be used everywhere. It generates different results for different queries.
The definition of the condition with the setting All Characteristics in the Drilldown Independent returns the same result as the definition of conditions for each separate characteristic. In this example, you can also define one condition for Sales Channel and one for Product to answer the same query.
· You could define the following condition for sales channel:
a. In the dialog box, choose Defining a Condition in the Evaluation of Conditions Below for Single Characteristics and Characteristic Combinations.
b. Select the Sales Channel characteristic.
c. 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 3 as the value.
· You could define the following condition for product:
...
a. In the dialog box, choose Defining a Condition in the Evaluation of Conditions Below for Single Characteristics and Characteristic Combinations.
b. Select the Product characteristic.
c. 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 3 as the value.
In the query, you need to actively set both conditions to get the same results as displayed above.
The setting All Characteristics in Drilldown Independent is more efficient in this case and allows you to use the condition in a very general way very easily. In this example, you do not need to define a condition for each and every characteristic to make the condition apply to all characteristics individually.