Hi Bruce,

In Crystal Reports, it is a requirement that sorting is first done by all fields selected as Groups. And then any other fields can be used for sorting.

If you want to have a tertiary sort by Sales$ descending (after Category and Brand), then you cannot have a group by SKU. Based on your posted results, you probably don't as the records are not sorted by SKU.

Just click on the Sales$ field in the Detail section, go to the Reports menu and pick Sort Records. Then add the Sales$ field to the sort list and choose Descending.