Try this.
From the Reports menu, pick the Top N / Sort Group Expert.
Find the tab related to the 3rd Group (by SKU).
Choose ALL, based on the Subtotal of Sales$ by SKU. Sort Descending.

For me, this resorted the Group 3 Footer records by the Sales$ subtotal, rather than the Group 3 name.