Filtering data is a very important part of data analysis and visualization. MicroStrategy Desktop provides a variety of options to filter data in a report. It has simple filters, which get the data based on the values selected by the user. It also has features to create complex features, which will filter out data based on the calculations.
In this chapter, we will learn the basic steps to create a filter on a column with non-numeric values.
In this example, we aim to create a filter on the field subcategory in a grid report made up of the fields category, subcategory, and sales.
Create a new visualization by choosing the fields category, subcategory as the rows and sales as the metric. The visualization is shown in the following screenshot.
Go to the Filter tab next to the Editor tab. Drag the field subcategory to this tab. It will automatically create a filter of type Dropdown as shown in the following screenshot. Also note that the number of values for this are shown in parentheses (25).
Now check mark the specific values on which we want to filter out the results in the report. On checking these values, only the respective results are visible in the report.