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

> 1 | Select the cross tab.

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

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

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

> | Choose Group level to filter data in a specific dimension, then select a 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.

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

> | Choose Detail to filter on a field that is not used in the cross tab, but that is defined in the cube.

> In Filter Condition, the first field displays the expression of the selected group or measure. You can change this value.

> 2 | Complete the filter condition by specifying the following information:

> 1 | In the first field, select a dimension or a measure, or a group total for which to evaluate values. Alternatively, choose the expression builder button to create an expression.

> 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.

> Figure 16-14 shows an example of a complete filter condition. The filter limits the data to include only states not equal to CA.

> Figure 16-14 New Filter Condition showing an example of a complete filter condition

> 3 | Choose OK to save the filter.

> 4 | Preview the report. Figure 16-15 shows an example of the filtered report.

> Figure 16-15 Cross tab report, filtered to remove data for sales in CA

(c) Copyright Actuate Corporation 2013