Related Topics

Table Elements

Using Fields in Tables

Formatting Columns and Headers

Sorting Tables

Groups allow you to create detailed data rows. For example, if you have a table that lists the suppliers for a national restaurant chain, you can group the suppliers by the "State" field. The suppliers' names are then rearranged so that all suppliers located in Maine, for instance, are located under a "Maine" header row; suppliers in Maryland are together under a "Maryland" header row, and so on.

You can use multiple fields to make more specific nested groups. By adding a group based on the "City" field to the table described above, the restaurant suppliers are arranged by City within the State groups. Under the "Maine" header row, new header rows for Augusta, Bangor, and Portland are added, and the names of the Maine-based suppliers appear under their respective cities. Under the "Maryland" header row, header rows for Annapolis, Baltimore, and Silver Spring are added, and the names of Maryland-based suppliers appear under those headers, and so on.

Only fields can be applied to a table as a group–measures cannot.

Data is grouped in the table according to the order they have defined. You can change the order by dragging the groups into position if needed.

To create a group, complete the following steps:

In the Domain Selection panel, click to select the field you want to add to the table as a group.
Drag the field to the Groups box in the Layout Band.

The Ad Hoc view refreshes and displays the data grouped under a new header row.

You can also add a group to the table by right-clicking a field and selecting Add as Group.

To remove a group, complete the following step:

In the Layout Band, click the X icon next to the field's name in the Groups box.

To move the grouping order up or down in a table:

In the Layout Band, drag the name of the group you want to move into its new position.