DEFINE question - new user

[rbc007]

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)

 

[rbc007]

completed...thanks