×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DEFINE question - new user

DEFINE question - new user

DEFINE question - new user

(OP)
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)

RE: DEFINE question - new user

(OP)
completed...thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close