Defining a filter at the report table level
7This section describes the procedure to create a filter at the table level. You can create a simple filter as described in the previous section. In addition, you can also choose multiple values for a filter condition by using the In operator, choose to exclude specific data, create a filter on empty values in the data fields, display the top or bottom N values, or specify a date as the comparison value. You can create a filter condition that compares values in a column containing string data to a string pattern instead of to a specific value. You can also create a filter condition that compares values in one column to values in another column.
When BIRT Studio evaluates a filter condition, it displays data that meets the specified condition, but users can specify whether or not the aggregate data in the report is recalculated to meet the filter condition. This feature is useful when comparing the filtered data values with the unfiltered totals, for example, when performing a percentage calculation of the unfiltered aggregate totals. You can specify whether to recalculate totals when creating a filter condition at the report table level.

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2