Previous Next

How to filter data at the cross tab level

1
2
3
1
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
3
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‑29. Alternatively, choose <Build expression...> to create an expression.

Figure 17‑29
2
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‑30 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‑29.

Figure 17‑30
4

(c) Copyright Actuate Corporation 2009