Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options › Example 1: Grouping CCCTAB or CCCMOD fields

Example 1: Grouping CCCTAB or CCCMOD fields

To select fields for viewing in a summary-with-breaks report:

• Set the Summarize and Break fields to Y (see A below)
• Enter Y in the Brk column for the ORD Type and Charge Element fields (see B below)

 + --------------------------------------------------------------------------- +
 | Type information for Query CPUCOST   Desc CPU COST FOR PER.1-3    Table TAB |
 | Summarize Y  Break Y  Bud/DBCR N           Version : PROD PROD              |
 |            A.                     Brk Srt                            Op Sum |
 | ORD Type . . . .                   Y      Rec Count                   > SUM |
 | Charge Element .              B.   Y      Units  . .                  > SUM |
 | Qualifier  . . .                   N      Rate . . .                  > AVG |
 | Period Number  .       thru        N      Charge . .                  > SUM |
 | DIVISION . . . .                   N                                        |
 | DEPARTMENT . . .                   N                                        |
 |                                                                             |
 |   F2=Exec   F5=Save   F6=Delete   F11=Refresh                               |
 +-----------------------------------------------------------------------------+

The panel below shows the results of selecting fields ORD Type and Charge Element for viewing. Note the following:

• There are three distinct combinations of ORD Type and Charge Element (see A below). CA PMA Chargeback displays each group separately. The groups shown below are those records where ORD Type = MBJ and Charge Element = CPU-CHARGE (see B and C below).
• The Record Count, Units, and Charge fields D, E, and G below are summations of the Record Count, Units, and Charge values for those records where ORD Type = MBJ and Charge Element = CPU-CHARGE.
• The Rate field (see F below) is an average rate of those records where ORD Type = MBJ and Charge Element = CPU-CHARGE.

 +-- CBQQRYB ----------------- Charge Query Results ---------------------------+
 |       Panel   Exit   Help                                                   |
 | -------------------------------------------------------------------A.------ |
 |                                          More: + - 1     Row: 0001 of 0003  |
 |  Table  . . . . . : TAB                                                     |
 |  Version  . . . . : PROD PROD         Record Count :              134   D.  |
 |  ORD Type . . . . : MBJ   B.         Units  . . . :         68.16665    E.  |
 |  Charge Element . : CPU-CHARGE C.    Rate . . . . :        159.05882 AVG F. |
 |  Qualifier  . . . :                   Charge . . . :      14459.99500   G.  |
 |  Period Number  . :                   Debit Amt  . :                        |
 |  DIVISION . . . . :                   Credit Amt . :                        |
 |  DEPARTMENT . . . :                   Adjust Charge:                        |
 |                                       Budget . . . :                        |
 |                                       % of Budget  :                        |
 |                                                                             |
 |   F7=Bkwd   F8=Fwd                                                          |
 +-----------------------------------------------------------------------------+