> #### How to filter data at the cross tab level

> 1 | Select the cross tab.

> 2 | In Property Editor, choose Filters and choose Add.

> 3 | On New Filter Condition, specify the following information:

> 1 | In Target, choose one of the following options:

> o | Choose Group level to filter data in a specific group. For example, if the cross tab displays sales totals by product line and by year, you can create a filter to display data for certain product lines or for certain years.

> o | Choose Measure to filter measure data. For example, you can create a filter to display sales totals greater than a specific number.

> 2 | In Group Level or Measure, select the group or measure on which to filter.

> 3 | In Filter Condition:

> 1 | In the first field, choose <Filter by...> to select a dimension or a measure, or a group total whose values to evaluate, as shown in Figure 17‑32. Alternatively, choose <Build expression...> to create an expression.

> Figure 17‑32 | Filter By displaying the items that you can use in a filter condition

> 2 | In the second field, select the operator that specifies the type of filter test.

> 3 | In the third field, specify the value to search in the dimension or measure specified in the first field. You can type a value, or choose <Select value...> to display a list of values. You can also specify an expression that evaluates to a value. Choose <Build expression...> to open the expression builder.

> Figure 17‑33 shows an example of a complete filter condition. The filter limits the data to only the years where the annual sales exceed 2000000. The annual sales is calculated by the data field, EXTENDED_PRICE_Group2/year, under Grand Total in the Filter By dialog box shown in Figure 17‑32.

> Figure 17‑33 | New Filter Condition showing an example of a complete filter condition.

> 4 | Choose OK to save the filter.

(c) Copyright Actuate Corporation 2009