How to Create Report Totals and Subtotals › Creating Levels of Nested Subtotals

Creating Levels of Nested Subtotals

In this step, you list the number of employees in each project group. For example, you can find out how many people are currently on your department's planning committee.

Because each department has a planning committee, this kind of calculation requires two group levels:

• Group level 1 groups the employees according to which department they work in. DEPT-ID is the group field.
• Group level 2 groups the employees within each department according to which project they are currently assigned to. PROJECT is the group field.