Previous Topic: Creating Levels of Nested SubtotalsNext Topic: Step 2 - Specify your subtotal

How to Create Report Totals and Subtotals › Creating Levels of Nested Subtotals › Step 1 - Specify your group level

Step 1 - Specify your group level

Start on the Report Format - Sort screen. To get there, type Sort in the command line.

Specify that you want to group by PROJECT within each department group.

     CA OLQ Release nn.n                           *** Report Format - Sort ***
 ->                                                       Page     1 of     1
133000 Specify sort or group by request and press the ENTER key

                                           Disp      Sort    Order     Group By
                                           Seq     Priority  (A/D)      Level #
   EMPLOYEE
 X  EMP-LAST-NAME                           4         _        _          _
 X  DEPT-ID                                 1         1        A          1
 X  SALARY-AMOUNT                           3         3        A          _
 X  PROJECT                                 2         2        A          2









           Display lines:  Detail X  and/or  Summary X       Group by all X
 Compute:

 1=HELP      3=QUIT      4=MESSAGE      5=DISPLAY      6=MENU      11=HEADER