Group Data

Group data items in a list report to remove duplicate values. For example, you have a report that shows products purchased. For each product, the product type is also shown. You group the product type column to show only one instance of each product type in the list.

Grouping a column automatically moves it to the left as the first column. Grouping a subsequent column moves it to the left until it follows the last grouped column. When you ungroup a column, it moves to the right until it follows the last grouped column.

After a column is grouped, you can move it elsewhere in the report.

In addition to grouping, you can specify the sort order of data items. In lists, you can sort data items within groups as well as ungrouped items. In crosstabs, you can sort row and column items.

Procedure

Click the column on which to group.
You can click either the column heading or one of the column cells.

Tip: To perform multiple groupings at once, use Ctrl+click or Shift+click.
Click the group/ungroup button .