Threshold Condition for a Characteristic in a Cross-Classified Table 

You have the following example query in which you are analyzing the net revenue of your products in relation to your customers:

The Product characteristic is located in the rows and the Customer characteristic and the key figure Net Revenue 2001 are located in the columns.

The query looks like this:

Note that a scaling factor of 1000 is used in this example query. The values in the condition definition refer to the actual values because the scaling factor is not considered in the evaluation of the condition. In the query, the values are displayed with a scaling factor of 1000. For more information, see Background Information on Conditions.

Now you want to see each product that has a net revenue of more than $240,000. Define the following condition:

       1.      When you are defining the condition, choose Single Characteristics and Characteristic Combinations, under Characteristic Assignment.

       2.      Select the Product characteristic.

       3.      Enter the following condition row:

Choose the structure Net Revenue 2001, the operator Greater Than and enter 240,000 as the value.

In the query, you see each product that has a net revenue of more than $240,000.

The system proceeds as follows:

At first, the condition is only applied to the results rows, that is the borders of the matrix. Then the single values within the borders are filled.

The two products Business Card Case and Coffee Mug do not fulfill the condition, which means that these rows are hidden.

Rule 8: Conditions in Cross-Classified Tables

In a cross-classified table, which means that characteristics are not only in the rows, but also in the columns, conditions are only applied to the axes. The axes span across the border of the matrix and all cells are displayed for which both the rows and the columns correspond to the active conditions.