MicroStrategy - Creating Filters

Filtering data is a very imporatnt part of any data analysis and visualization. Microstratgey Desktop provides a veriety of options to filter data in a report. It has simple filters which get the data based on values selected by user. It also has features to create complex features which will filter out data based on calculations.

In this topic we leanr the basic steps to create a filter on a column with non-numeric value.

Example

We aim to create a filter on the field subcategory in a grid report made up of the fields category, subcategory and sales.

Step-1

Create a new visualization by choosing the fields category, subcategory as the rows and sales as the metric. The visualization is shown below.

Step-2

Go to the Filtertab next to the Editor tab. Drag the field subcategory to this tab. It will aoutomatically create a filter of type Dropdown as shown in the diagram below. Also note that the number of values for this are shown in parentheses (25).

Step-3

Now check mark the specific values on which we want to filter out the results in the report. On cheking these values only the respective results are visible in the report.