How to Sort Customers by Total Order Value in Descending Order

Hi community,

I'm customizing a report in Acumatica Report Designer. I have grouped the data by SOOrder.CustomerID because each customer can have multiple orders. Inside the group, I'm calculating the total order value per customer using =Sum(SOOrder.OrderTotal) and then multiplying it by a tax rate to get a field called "Order Value."

Now, I want to sort the report lines (i.e., each grouped customer section) in descending order based on the total order value per customer.

I tried adding SOOrder.OrderTotal to the sorting section, but it only sorts the individual orders, not the grouped result. Is there a way to sort the groups (customers) by their summed order total?

Any thoughts or suggestions would be appreciated.

Thank you!