Group columns

The group-by function lets you sort data at more specific levels. This example shows a view that groups customer names and their business addresses.

Note: The ColumnGroupingEnable custom property must be True before you can use this function.

To use the Group-by function

1. In the Table, View or Query box, type the name of a table or view or select the arrow to display a list of pre-determined items. For details about pre-determined items, see View Data.

2. Select Group-by. The Drag a column header area appears.

   

3. Drag a column heading to the upper area.

   

4. To view the data groups, press Enter to expand any of the StateProvince items.

   

5. To see a more specific sorting of the data, drag another column heading to the upper sorting area.

   

6. If you want to sort the data at an even finer level, you can repeat steps 3 and 4 and drag another column heading to the sort area.

7. If you want to remove one of the column headings from the sorting area, drag it down to the data area.

   

8. To return the original dataset, select Group-by.