Sorting a "Sum of" formula in the Group Header

[stalukder]

hello,

I am trying to rank our sales reps based on total sales in the group header. Right now I got the total sales for each rep in a SUM formula in the group header. Is there a way to sort the SUM of Sales field where the rep with the most sales comes up first.

So for example.

Group Header:

Person A - Sales $1000.00
Person B - Sales $2000.00
Person C - Customer Service $1500.00

I want it show the following on the group header...

Person B - Sales $2000.00
Person C - Customer Service $1500.00
Person A - Sales $1000.00

Any help you can provide would be great.

Thanks!

 

[lbass]

To do a group sort, you must be able to insert a summary on a detail level record, so you if you can right click on the sales field->insert summary->sum, you can then go to report->group sort and use sum of Sales as your group sort field. If you can't insert a summary, you should show us the content of your summary formula.

-LB