I've generated a report that groups the calls by id.
In the query, I'm pasted another ID column with "count" as the total.
In the report, I have sorted by id so I can place a =sum([count of ID]) which total the calls for the id.
I'm having problem with sorting the id's according to the # of calls (Descending order). I tried sorting by count of ID but with no luck.
Can you guys help me out here. Is there a simpler way of counting/summing the calls by id then sorting in a report.
Thanks
kastaman
In the query, I'm pasted another ID column with "count" as the total.
In the report, I have sorted by id so I can place a =sum([count of ID]) which total the calls for the id.
I'm having problem with sorting the id's according to the # of calls (Descending order). I tried sorting by count of ID but with no luck.
Can you guys help me out here. Is there a simpler way of counting/summing the calls by id then sorting in a report.
Thanks
kastaman