Grouping Product Type and Sorting
I need to group by Product Type firstly, and then subtotal their cost of their orders. So each product has a subtotaled cost. This worked fine before because then it was sorted by ascending Product Type Number. However now I need to sort by descending subtotaled cost amount.
When I create the sort, I just sort by this subtotaled cost amount but it keeps splitting up subtotals for the same Product Type. Is there any way I can group by Product Type FIRST and then sort by subtotaled cost?