Project 2000. Custom Fields and Grouping, страница 19

4.  In a consolidated project, grouping will work across all tasks in all of the projects, ignoring the projects’ outline structure, except if a project is collapsed, only the collapsed project summary task will be included in the grouping.

5.  The order of grouping will depend on whether the group is by ascending or descending order.

Sorting and Filtering

All standard sorting and filtering operations can be performed along with grouping, either before or after grouping is applied. There are two exceptions when sorting is combined with grouping; the sorting options to “Permanently renumber tasks” and “Keep outline structure” are ignored and unavailable.  For filtering combined with grouping, the setting for “Show related summary rows” is ignored. Any sorting or filtering performed, applies only to the actual tasks or resources in the project, though the group summaries may be rearranged in order to keep them with their subtasks after sorting.

Sorting

When sorting is combined with a grouped view, the tasks or resources are sorted within each group. Group header rows always stay with their subtasks, and the last operation performed (grouping or sorting) takes precedence in the arrangement of the group headers.

For example, suppose we have the following list of tasks:

ID

Name

Work

Start

1

T1

24h

1/1/98

2

T2

16h

1/1/98

3

T3

16h

1/2/98

4

T4

8h

1/2/98


If these tasks are grouped by Start (Descending) and then sorted by Work (Ascending), the following will be the result:

ID

Name

Work

Start

Start: 1/2/98

24h

1/2/98

4

T4

8h

1/2/98

3

T3

16h

1/2/98

Start: 1/1/98

40h

1/1/98

2

T2

16h

1/1/98

1

T1

24h

1/1/98

If the tasks are then regrouped by Start (Ascending), the result is as shown below. Note that within their groups the tasks remain sorted by Work (Ascending), but the group headers have been rearranged according to the group definition.

ID

Name

Work

Start

Start: 1/1/98

40h

1/1/98

2

T2

16h

1/1/98

1

T1

24h

1/1/98

Start: 1/2/98

24h

1/2/98

4

T4

8h

1/2/98

3

T3

16h

1/2/98

Filtering

For non-highlight filtering, the order of applying the grouping or filtering makes no difference. Grouping will be applied according to standard rules, on all tasks remaining after the filter is applied.

For highlight filtering, grouping will be the same as when no filter is applied, except that those items, which satisfy the filter criteria, will be highlighted appropriately.


Rollup Calculation for Non-Summary Task Fields

General Rollup Behavior for Group Summary Headers

Rollup behavior is essentially the same as for normal summary tasks. For example, the Work value in a group summary header will be the sum of the Work value for its subtasks; the Start value will be the lowest Start value for any subtasks; Finish value will be the highest Finish value; etc.

Though external tasks are grouped along with other tasks, their field values are not included in group summary header rollup values.