Doing this is possible, but not easy.
One way to implement sorting by a sum is to do the following:
1) Create a custom field in the relevant table to store a particular sum. For example, if the report is based on contacts, and the sum is on opportunities for each contact, then add the field to the contact table. See the help file for details on customizing the data dictionary.
2) Have the custom field call a user defined function that, given a contact, calculates the sum manually for that contact. See the help file for details on user defined functions.
3) Add the custom field to the report and sort on it. You can hide the field from the report entirely if you like (in older versions, set the width to 0), but it still needs to be included.
Trevor |