One of the reports we have is where this information is grouped by the donor's name and there's a summary total for monetary columns like total amount donated. 

For example:

John Smith

donation#       Total Amount

      1                 50.00

      2                 35.00

                         85.00

We would like to have another report that's sorted by the grand total per person (descending) so we can see which person donated the most in total so far, then the next person, etc. 

Based on the example above, the report would then display with Sam Spade first since his total donation amount was $1025.00, then John Turner since his total donation amount was $300 and lastly John Smith since his total was only $85. This way we can see who's currently our biggest donors.

I've tried for hours trying to find a way in Zoho Creator to do this but haven't been able to figure out a way to do it. 

Is there a way in Zoho to create a report that's sorted by the grand total of a column within a sort (display = total)?

Thank you for your help.

Jim K.