In Pentaho Analyzer, 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 Analyzer report:
-
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.
Note: 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.
-
If you selected Greater/Less Than, Equal to, etc., do
the following:
- In the first field (measure), select the member dimension that you want to use from the drop-down menu, such as Quantity or Sales.
- In the second field (filter), select the measure that you want to use from the drop-down menu, such as Greater Than or Equals.
- In the third field (level), enter the value for the measure.
-
If you selected Top 10, etc., consider if you want to
filter from the top or bottom of your list. Then do the following:
- 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.
- Click in the by [measure] field and from the drop-down menu, select the member dimension that you want to use for the filter.
