How to Create Report Totals and Subtotals › A Quick Example: Creating a Subtotal › The Report Format - Group By screen

The Report Format - Group By screen

You specify your group calculations on the Report Format - Group By screen. The Report Format - Group By screen looks like this:

      CA OLQ Release nn.n                      *** Report Format - Group By ***
  ->                                                       Page     1  OF      1
 136000 Specify summary computations and press the ENTER key

  Group by: OLQ-EXAMPLE.COUNTRY                                         Level# 2
           NEXT _                           Seq   Sum   Avg   Max   Min   Count _
    OLQ-EXAMPLE
  X  LAST-NAME                              1      _     _     _     _
  X  COUNTRY                                6      _     _     _     _
  X  FINISH-TIME                            5      _     _     _     x
  X  SEX                                    4      _     _     _     _









              Skip lines after group  1     Separator character -
  Compute:

  1=HELP      3=QUIT      4=MESSAGE      5=DISPLAY      6=MENU      10=PICTURE

Group by displays the current group field. Level # displays the current group level. Sum, Avg, Max, Min, and Count are mathematical functions that you can apply to any report column. These functions apply to the extent of the current group level.