
I would like the report to be sorted by highest grand total. I see how to sort by things like account name but not by totals.
2 Antworten

This is a situation were I find it better to work in Excel.
If this will be a regular report, I would use the Connect for Office Excel add-in to import your report into Excel. Then I would create a pivot table based on your report detail. When you use the Excel add-on to refresh your report, the pivot table should auto-update.
Here's a link on the Connect for Office add-in.
https://na5-api.salesforce.com/help/doc/en/salesforce_office_edition_cheatsheet.pdf
Here's how you would group the pivot table.
Group Rows by Account Name.
Sort the Account Name by descending values.
Group Columns by the required date field (Group the date field by month if necessary)
Sum the Amount field.
Aiden