Have you tried playing with this: Click on the SORT tab and group on your Department field. Then go to the Statistics field, do a total a COUNT, and set the COMPUTE ON to your Department field.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brad Terhune Sent: Friday, August 31, 2007 12:52 PM To: arslist@ARSLIST.ORG Subject: Remedy Reports Good afternoon list! It has been some time since I did reporting out of Remedy using the User tool. I could use a little help. I messed with it a bit today and have been unable to get the report I want. I'm wondering if it is possible to do straight out of the Remedy User tool. I want to generate a report that lists the number of calls we have received from each department (every case has a populated department field). I have also created a drop down menu that has a default of .25 but can go as high as 40. I want the report to sum the value of this field by department. For example: College of Allied Health 432 cases Sum of field = 46 College of Engineering 521 cases Sum of field = 121 And so forth and so on. So far, I can only get the report to list one case after the other with department listed over and over, the drop down value listed over and over . . . I cannot get it to group the department field and work on the relevant associated data for cases with that department designation. I'm sorry if this makes no sense. Thanks in advance for any help you could provide. Brad Terhune ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
