To group table records by column values
Click the title of the column you wish to group table records by and drag it to the Grouping area. Table records will be grouped by the values of the grouping column:
You can group a table by several columns if necessary. In this case, the relative left-to-right order of the columns in the Grouping area will correspond to the top-to-bottom grouping order of the table records:
Optionally, set an aggregate function for the desired columns.
To ungroup table records by column values
In the Grouping area above the table header, right-click the name of the column you want to ungroup data by and select Ungroup By from the shortcut menu:
Table records will no more be grouped by the values of this column.
Hiding / Showing table columns
Rearranging table columns
Setting an aggregate function for a column