I'm trying to use this report and it's miserable.

We have subcategories of inventory.

I just want to easily see the item sold, qty sold, and amount of sales.

And then be able to sort by qty sold or amount.

I cannot do this because it won't allow me to sort any other way then "total" or "default".

I need to be able to run this report WITHOUT the category...JUST THE ITEM NAME/NUMBER.

Any suggestions?