How to filter at the group level These instructions assume that you have already created a table that displays data from a data set, and created a group or groups to organize the data. 1 In the layout editor, select the table that contains the data to filter. 2 In Property Editor, choose the Groups tab. Property Editor displays the groups that you defined for the table. 3 Double-click the group whose data you want to filter. Edit Group displays the properties of the group. Figure 11‑8 shows an example. Figure 11‑8 Edit Group 4 Under Filters and Sorting, choose the Filters tab. 5 Choose Add to create a filter condition. 6 On New Filter Condition, specify the filter condition, then choose OK. Figure 11‑9 shows an example of a filter condition defined for a group. Figure 11‑9 Filter condition for a group 7 Choose OK. 8 Preview the report to verify the results. The report displays a different set of group values.
These instructions assume that you have already created a table that displays data from a data set, and created a group or groups to organize the data.