Using the Group By Box

You can group records by one or more column headers by using the Group By box. The Group By box appears as a gray area in the pane that displays "Drag a column header here to group by that column" text.

When you add column headers to the Group By box, Data Builder groups the displayed records according to the data in the specified columns. The column header groups are arranged hierarchically in the order in which you added them.

To show the Group By box

To add a column header group to the Group By box

To hide the Group By box

After you add one or more column header groups to the Group By box, you can perform the following operations:

Drag and drop the groups to easily reorder them.
Switch the order of the items within the group between ascending and descending by clicking or next to the group name in the Group By box.
Filter the items within the groups. To do this, point to the group name that you want until the filter icon () appears. Click this icon, and then click the filter criteria that you want to use from the list of valid values that is displayed.
Expand or collapse the groups to show or hide all the items. To do this, right-click a group, and then click either Full Expand or Full Collapse. (If you want to expand or collapse an individual group or subgroup in the pane, select the group or subgroup, and then click or to expand or collapse the items.)
Clear all the groupings. To do this, right-click in the Group By box, and then click Clear Grouping.
Ungroup a specific group. To do this, right-click the group that you want, and then click UnGroup. Alternatively, drag the group that you want to ungroup to the location in the column header row where you want to place it.