Previous Topic: Creating Groups and Specifying SubtotalsNext Topic: Step 2 - Specify your subtotal

How to Create Report Totals and Subtotals › Creating Groups and Specifying Subtotals › Step 1 - Specify your group level

Step 1 - Specify your group level

In this step, you calculate the average salary in each department.

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

Specify that you want to group your employees by department by entering a 1 next to Group By Level #. Specifying 1 means that DEPT-ID is the highest level group field. You may later create subgroups within each department.

     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          _









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

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