I'm looking for help in producing a report to count and group or role up by "titles" see figure2.  

What I need is a DEFINE statement or your suggestion to exclude in -figure2- any value before "(oc:" result (Escalation, Follow-up Call) grouped.    

Currently the report is counting each field as a different value because of the names after "(oc:"  =our client.


eXAMPLE:        -figure1-
TABLE FILE DATABASE1
SUM
     CNT.TITLE AS 'COUNT'
BY
     TITLE AS 'TITLE NAME'
ON TABLE SUBHEAD


current rEPORT-EXAMPLE with TITLES:   -figure2-

Escalation (oc: Jim williams)            1
Escalation (oc: Mike williams)          1
Escalation (oc: Mike John)               1
Escalation (oc: Michael williams)       1
Escalation (oc: Mike Bond)                1
Escalation (oc: williams smith)          1
Escalation (oc: Mike jones)               1
Escalation (oc: Mike schott)
Escalation (oc: Mike lee)
Escalation (oc: jones Wong)
Follow-up Call (oc: Mike Bond)
Follow-up Call (oc: Mike williams)
Follow-up Call (oc: Mike jones)
Follow-up Call (oc: Mike williams)
Follow-up Call (oc: Mike williams)
Follow-up Call (oc: Mike williams)
Follow-up Call (oc: Mike lee)
Follow-up Call (oc: Mike williams)


Should be;
Escalation            12  (total value)
Follow-up Call        17  (total value)