When you are displaying your data in the Data Display window, you can use a function of the grid to automatically group your data by particular columns.
If you select View > Group-by Box (or Ctrl+G) AQT will display a Group-By box at the top of the display. This allows you to group your data by particular columns; this function is extremely useful for analysing your data.
If you drag a column to the group-by box, the data will be grouped by that column. You can group-by multiple columns.
You can expand or collapse sections of the group hierarchy by clicking on the + or – icons or double-clicking the item.
View > Collapse Rows / Expand Rows will collapse or expand the group hierarchy.
If you are grouping by multiple columns, Collapse/Expand will just collapse or expand the top column in the grouping. You can also use View > Collapse All or Expand All to collapse / expand all groups in the hierarchy.
You can expand or collapse the grouping by double-clicking the column in the Group-By box. Note that if you expand a column, but one of the higher-level column is collapsed, you will not see the expanded data. The columns at the higher levels will also need to be expanded.
You can removing the grouping by dragging the column and dropping it onto the grid (ignore the large X that you see when you do this).
Once you have grouped your data, you can calculate sub-totals on the data.