To group data by column, click the Show Group by Box icon on the document toolbar. The Group by Box panel will appear above the grid. Drag a column header you want the data to be grouped by to this panel.
Also, you can right-click the required column header and select Group By This Column on the shortcut menu. The data is automatically displayed in groups marked with collapsed nodes. The column header is moved to the Group By Box panel.
Actual document look may slightly vary from the above image, depending on the product you use.
Group By Box is the area above the data grid where you can see the grouping order and perform further grouping-related operations. Drag a column header to Group By Box to group the data by that column. You can group the data by multiple columns.
In this case, the grid will display a tree of nested groups that you can expand by clicking + buttons. To collapse the groups, click - buttons.
To expand and collapse all groups at once, right-click the Group By Box panel and select the Full Expand or Full Collapse options on the menu.
To cancel grouping by column, drag-and-drop the column header from the Group By Box panel to the required place in the grid or right-click the column header and select Ungroup on the menu.
To remove all the fields from the Group By Box panel, right-click it and select Clear Grouping on the menu.