How to filter data at the cross tab level
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.
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 Filter By displaying the items that you can use in a filter condition
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 New Filter Condition showing an example of a complete filter condition.
(c) Copyright Actuate Corporation 2009 |