Sorting and Grouping

Use the Sort panel to reorder the columns of the table, to define how the data should be grouped, and to specify what calculation to display in the footer row.

_

Reordering Fields

To reorder the fields, drag a row and move it up or down as desired. The letters refer to the columns as it is customary in all spreadsheet applications: the first column is A, the second B, and so on.

Primary Grouping

You can organize the data in the schedule in groups defined by a field. For example, in a Wall schedule you can group the listed walls by Type so that all the walls of the same type will be listed together. If you used four wall types in your project, the schedule will display four groups.

To select which field defines the primary grouping, click its cell in the second column. The check-mark indicates the current primary grouping field.

Only one primary grouping field can be selected.

Sorting

_

The items in the group can be further organized by selecting a sorting criterion.

You can sort the items from first to last, last to first, or leave them unsorted. In this latter case, the items are listed in the order in which they are in the project.