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.