How to Create Report Totals and Subtotals › Creating Report Totals › 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.

Select Group by all to include all of the rows in your report in a group computation.

     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          _

   COMPUTE FIELDS:
 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E
   MPLOYEE.SALARY-AMOUNT) GROUP BY
    EMPLOYEE.DEPT-ID LEVEL 1




           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