Let's say a simple sold product report based on product table and order table (linked by sku relationship)

Group by:

Product name [product.name]

Summarize:

Sold Quantity [sum(order.ordered_qty)] 

User filters:

Date picker - (titled: Orders from within date period)  [order.order_created]

This works in principle, however we can't sort by the Sold Quantity, the business stakeholder want to see the top selling products for the period they selected at the top of the report by default.

Sorting does not work in this example. Is this a known bug /  major omission?