Skip to Content
0
Former Member
Mar 03, 2009 at 06:02 PM

Sort on formula in second group - Help

26 Views

I need a little help. Even though I've used Crystal Reports for years, I only use it a little.

I have a database that lists each of the automobile crashes in the City. I group this data based on the intersection, sum (count) the number at each intersection, and then calculate a rate (count/volume). I want to sort the data based on this rate, but since I've grouped on the intersection first to get the count of the crashes at the intersection, the sort on the rate I can't figure out how to do.

Any ideas?