A Quick Example: Creating a Subtotal

How to Create Report Totals and Subtotals › A Quick Example: Creating a Subtotal

A Quick Example: Creating a Subtotal

          ┌──    Creating a Report Subtotal
          │   ┌────────────────────────────┐
          │   │

Step 1

                     │
          │   ├────────────────────────────┤
          │   │                            │
          │   │ Sort Report Rows           │
          │   │                            │
          │   │                            │
          │   │                            │
          │   │                            │
Report    │   └─────────────┬──────────────┘
Format-   │                 │
Sort      │                 │
screen    │   ┌─────────────▼──────────────┐
          │   │

Step 2

                     │
          │   ├────────────────────────────┤
          │   │                            │
          │   │ Specify Report Groups      │
          │   │                            │
          │   │                            │
          │   │                            │
          │   │                            │
          │   └─────────────┬──────────────┘
          └──               │
          ┌──               │
          │   ┌─────────────▼──────────────┐
          │   │

Step 3

                   ──┼─────►  Aggregate functions
Report    │   ├────────────────────────────┤          - COUNT
Format-   │   │                            │          - SUM
Group By  │   │ Specify Group Calculations │          - AVERAGE
screen    │   │                            │          - MAXIMUM
          │   │                            │          - MINIMUM
          │   │                            │
          │   │                          ──┼─────►  The COMPUTE statement
          │   └────────────────────────────┘
          └──

BOSTON MARATHON mm/dd/yy LAST NAME SEX FINISH TIME COUNTRY ------------------ --- ----------- -------------- GUERRIERI M 2:19:30 ITALY PARSONS M 3:00:04 USA VANDER WYK F 2:54:12 BELGIUM BJORNSEN F 2:59:12 SWEDEN BARBADO M 2:40:12 ITALY KEEFE M 2:40:19 USA KLEIN F 3:09:23 USA YAMADA M 2:30:41 JAPAN MARTIN M 3:10:29 FRANCE FRECETTE F 3:10:01 BELGIUM FUCCI F 3:40:37 ITALY BENOTTI F 3:12:42 ITALY

LAST NAME SEX COUNTRY FINISH TIME ----------- --- ----------- --------------------------- VANDER WYK F BELGIUM 2:54:12 FRECETTE F BELGIUM 3:10:01 HELFGOTT F BELGIUM 3:24:31 -------- FASTEST IN BELGIUM :2:54:12

On the Report Format - Sort screen:
- Step 1 - Sort your report rows.
- Step 2 - Create report groups.
On the Report Format - Group By screen:
- Step 3 - Specify your group calculations.