Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help finding a sum

Status
Not open for further replies.

auburnfan

Technical User
Jan 4, 2006
22
0
0
US
Hello everyone.
Here is the problem I am having. I have a report that is making a count of all the different origins in the table. The table looks like this.
{table_origin)
email
phone
walk up
fax
voicemail

What the report does is count each ticket placed under each origin by each team member.
Ex.
Jeffery placed the following tickets
Email - 12
Phone - 30
Walk up - 3
fax - 1
Voicemail - 5

Brad Placed the following tickets.
Email - 14
Phone - 28
etc...

So I need to figure out how to get a total count for each origin
ex.
email - 26
Phone - 58
etc..
The problem is that it is not letting me do a sum of a sum.
Does anyone have any clue how to get this to happen?

I am using CR 11.0.0.895

 
The easiest way to show this information is to add a crosstab to in the report footer

Gary Parker
MIS Data Analyst
Manchester, England
 
It took me a while to get it the way I wanted it, but it did work out. Thank you very much :D
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top