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. This privilege is part of OLAP Services.
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. The Filter On Metric dialog box opens.
Select an operator from the drop-down list 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.