How to Create a Filter Based on a Rank Range of Metric Values

You can create a filter that restricts report results based on a rank range of metric values for a given report. This can allow you to view analysis such as the bottom 20 products in terms of profit margin. Further analysis can be explored on this rank range of products to determine how to increase profit margins for these products, or decide which products should be discontinued.

The steps below show you how to create a filter with a rank metric qualification.

You need the Web Use View Filter Editor privilege.

To create a filter with a rank metric qualification

Log into a project in MicroStrategy Web.
Run the report in Grid View.
Right-click a metric on the report and select Filter On.
Select Top N.
Select an operator from the drop-down that describes how you want to filter data, such as Highest or Lowest.
Type the value for the rank number you want to restrict data to. This is the value that indicates the number of attributes you want to display.
Click OK.