Grouping data

Method

•Click and drag the column heading that you wish to group the information by into the area of the window marked 'Drag a column header here to group by that column'. In the image below the 'Instr' (instrument) column header is being dragged to this area:

•Drop the column heading in the marked area:

•The data is now sorted into groups according to instrument code. Furthermore, each group has a minus sign next to it, allowing you to expand or collapse groups. In the image below, the one group is expanded, whilst the others are collapsed:

Method

•To de-group grouped data, simply drag the column header from the grouping area and drop it anywhere inside the window's data area:

Method

•More than one column header can be dragged into the grouping area to create nested groups. The column headers will display the hierarchy according to how the data is grouped. It is also possible to drag the column headers within the grouping area of the window in order to change the grouping order.

•The user has the option of not showing the default grouping row. Right-click on the window and click on the checked Grouping Row.

•The image below displays the Grouping row removed: