Grouping

<< Click to Display Table of Contents >>

Navigation:  Table editors > Table editor basics > Grid >

Grouping

The Group By Box allows you to organize rows in a group based on the values in one or more columns.

 

clip0128

 

For example Customers grouped by City:

 

clip0126

 

Or Trucks by grouped Owner and within the Owner group, grouped by Vehicle Type:

 

clip0127

 

Creating a group

Groups are created one of two ways:

 

Dragging and dropping a Column header (in the example below, the Owner column) on the Group By Box

 

clip0129

 

Selecting Group By This Field from the Column context menu

Expanding and Collapsing groups

Groups can be expanded and collapsed. Expanding and collapsing of a group is accomplished by click the + and - symbols at the left of each  group header. You can also expand all groups using the clip0123 button and or collapse all rows with the clip0124 button. Alternatively you can use the Group By Box context menu to expand/collapse groups.

 

In this image, all groups are collapsed.

 

clip0120

 

In this image, the BOLTON PAVING group is expanded.

 

clip0122