Edit Grouping Hierarchy window (spreadsheet sort)

You use this window to define the sort levels each sequence uses, and the order in which the levels appear on the spreadsheet sequence tab.

To open the Edit Grouping Hierarchy window:

In the Edit Estimate Spreadsheet Sequences window, beside the Grouping Hierarchy cell for a selected sequence row, click the list List button button.

You select each sort level to include in the spreadsheet sequence as follows:

  1. In the Edit Grouping Hierarchy window, for each sort level you want to include, select the level, and then click the right arrow Image of the right arrow icon button.

    To remove a level from the sequence, select it on the Selected Fields list, and then click the left arrow Image of the left arrow icon button.

  2. To rearrange the order of sort levels, select a level on the Selected Fields list, and then use the up arrow Image of the Up arrow icon or down arrow Image of the Down arrow icon button to place the sort level in the priority you want.
  3. When you have finished setting the sort levels in the order you want them, click [OK].