When defining filters by measure, you can create rules to get a list of data for a defined threshold value and rules to get ranked list of data.
For these operators, you define a range of values that should be included or excluded in the list.
For these operators, you define a specific value to display members that are greater or less than this value.
For these operators, you define a specific value to display members that are greater or equal to or less or equal to this value.
For this operator, you define a specific value to display members that are equal to this value.
For these operators, you must enter a whole, positive number as the value. The ranked list is arranged according to the defined number.
For example, if you want a list of the three customers with the strongest sales volume and the five customers with with the weakest sales volume, you create a Top 3 and a Bottom 5 rule in the filter definition.
For these operators, you must enter a number between 0 and 100. The ranked list is arranged according to the defined percentage.
For example, if you want a list of the strongest products in revenue until 25% of the total revenue is attained, you create a Top 25% rule for this measure with regard to products.
For these operators, you can also enter a floating point number (15.7 for example). The ranked list is arranged according to the defined total value.
For example, you want a list of products with the highest sales volume, whose combined sales volume totals EUR 20,000. All sales volumes are first sorted in descending order. The totals are calculated until the threshold value of 20,000 is exceeded. If the last value that need to be included to achieve EUR 20,000, causes the total to exceed 20,000, it is also included in the list. All products with a lower sales volume than this product are no longer displayed. Products that exceed the EUR 20,000 threshold remain in the list.