Another report question.

I have a report that using a summary field to total a figure for each person.

It turns out you can't sort by a summary field.

So if you had a report that had, Bill recruited 10, John recruited 7, etc etc, and you wanted the report to list them in order by the total recruited, what would you do?

The only thing I can think of is to somehow get the data out of the summary field in to a new field for each person, then sort based on that.

thanks

I guess I should have held out a little longer.

Found the answer

Highlight the field you are sorting by then click on reorder by summary field.

Very simple but missed it 100 times

Dave