Let's take these data for example (grouped by Category)

 

Category                         Sales ($)

 

Category 1

    Item AAA                           100

    Item BBB                             50

    Item CCC                            30

Subtotal                                180

 

Category 2

    Item DDD                          200

    Item EEE                           100

    Item FFF                             50

Subtotal                                350

 

Is there any way that I can sort data based on Category subtotal, showing most sales on top (i.e Category 2 on top followed by Category 1)

 

Need help, thank you in advance