Users can refine the data set returned within a report by using the Filter tools within the Edit View. Below are the types of filters:
Applied to a single report table or report tab. They are similar to Query Filters but you cannot prompt on them.
A flexible way to allow end users to filter reports. Unlike Drill Filters, the look, feel, and operation of these filters can be customized. Input Controls can be applied to individual report pages or the whole document.
A filter based on a single object or variable, where only a single data point can be chosen at a time.
Creating Report Filters
Step 1 – Click the table that needs the filter
Step 2 – Click on the Report Element Data panel
Step 3 – Select the Filter icon
Step 4 – Drag an object or variable from the available objects into the drop box
Step 5 – To define the filter, click the desired value, or the gear icon for the settings
If Settings is chosen, choose the preferred Operator and any other requirements. Once set, hit the back button in the top left corner.
Step 7 – Click OK.
Step 8 - To remove a filter select the X icon in the filter box
Filters can also be accessed by right-clicking in the column that needs the filter, and selecting Data > Add Filter