Please can anyone kindly help on how to generate inventory sales report ranked from highest to lowest.
The easiest way to get that specific format is to create an Inventory Profit Margin report. Then copy it to a spreadsheet and sort by the Sales column. Delete any unwanted columns.
The effort to create a custom report would be quite substantial.