Filter

Lumel EPM provides filter by row or column hierarchies, or by measures, along with Nested AND/OR filtering options to filter a range of data based on the criteria you define.

Go to HOME > Filter > Add New Filter. Create Filter pop-up appears.

Create Filter pop-up.

• Enter a name for the filter.

• Select the measures to which filter has to be applied from the Category dropdown.

• Select the filter conditions from the adjacent dropdown.

• Click Save to apply the filter.

The data has been filtered to show only the rows corresponding to the category 'Audio' as shown in the image below.

_{Filter is applied to the Audio category.}

Once a filter is applied, it can be edited by clicking on the filter icon again.

You can apply filters on manual input rows, like calculated rows/static rows/template rows etc.

Nested Filters