How to sort by total amount?

[ClariceLim]

Hi, I need you advice. When I do a Vendors supply report, I can't sort it by the amount because of the report is group by vendor, automatically it will sort by vendor. So, how to sort it by amount? If I want to get only the top 10 vendors and the left put into 'Others', can it be done?

Thanks.

 

[ajubi]

U can try sorting with the Amount in the query u have written and group by the vendor in the report..