Norm is on the right track...

Add to that..

You do not need to list the Department field or the "drop down menu"
field in the field list. You can instead include the $Department$ (or
whatever the field Label/DB Name/Field ID is for the field in
question) in the Statistics tab 'Label' value for that calculation to
see the value that is being grouped on.

Example:
"
Status: $Status$
"

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.


On 8/31/07, Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]> wrote:
> 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: [email protected]
> 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"

Reply via email to