Skip to main content
Pentaho Documentation

Create a Filter on Measure Values

When you create a filter on measure values, specify one or more measure fields and one level field which indicates the values to filter. Later, if you remove the level field from the report, then the measure filter is also removed.

Note the following restrictions when applying filters on measure values which may affect your report:

  • You can have only one measure filter on a report at any given time.
  • Calculated fields cannot be used.
  • When the report is generated, the measure filter is applied after any other filters.

You can filter report data by applying conditions to the measure fields in the data in two ways:

  • Greater/Less Than, Equal to, etc.
  • Top 10, etc.

Perform the following steps to filter on a measure value in an Analysis Report:

  1. Log in to the User Console. Click Browse Files to browse to the location of your Analyzer report and open the report.
  2. Click the Add a Filter icon, then drag a field from the Available Fields panel (or click and drag a field or column from the report) that you want to use as a filter into the Filters workspace. The Filter dialog box appears.
  3. Select the Greater/Less Than, Equal to, etc. option and/or the Top 10, etc. option to filter the report on a specific measure data.

If your measure filter specifies both a Greater/Less Than, Equal to, etc. and a Top 10, etc. component at the same time, the Greater/Less Than, Equal to, etc. component is applied before the Top 10, etc. component. 

Analyzer_AnalysisReport_MeasureFilterDialog.png

  1. If you selected Greater/Less Than, Equal to, etc., do the following:
  1. In the first field (measure), select the member dimension that you want to use from the drop-down menu, such as 'Quantity' or 'Sales'.
  2. In the second field (filter), select the measure that you want to use from the drop-down menu, such as 'Greater Than' or 'Equals'.
  3. In the third field (level), enter the value for the measure.

Analyzer_AnalysisReport_MeasureFilterSelection.png

  1. If you selected Top 10, etc., consider if you want to filter from the top or bottom of your list. Then do the following:
  1. In the first field, select Top or Bottom from the drop-down menu, and then enter the number of items for the member dimension you are filtering.
  2. Click in the by [measure] field and from the drop-down menu, select the member dimension that you want to use for the filter.

Analyzer_AnalysisReport_MeasureFilterSelectionTop10.png

  1. Click OK to apply the filter to your report. After generating, your report displays with the fields matching those values.
  2. Save your report. You can click Undo or Reset to return to the previous version of the report.