Sort, pin, and group data in workspace grids
- Last UpdatedOct 25, 2024
- 2 minute read
For grids that appear in the tabbed workspace, the Properties window, and dialog boxes, you can sort the grid by columns, pin columns to freeze them when scrolling horizontally across the grid, and group the grid data by columns.
Sort a by column
-
Click the column heading. Click it again to change the sort order.
A grid can only be sorted one column at a time.
Pin a column
-
Click the push pin icon in the column heading.
The column moves to the left side of the grid. The column will now be visible if you scroll the grid horizontally.
You can pin multiple columns.
Unpin a column
-
Click its push pin icon.
The column moves to the right and is no longer pinned.
Group the grid data by columns
-
Click the thick group by area bar that is directly above the column headings.

The group by area appears.

-
Drag and drop a column heading on the group by area.
The grid entries are grouped by the data in that column. For example, the following grid is grouped by the Item Class ID column data.

You can continue to add column headings to group by. The groupings are nested according to the order that you drag the column headings.
Remove a grid data grouping
-
Drag it off the group by area.