Sorting option for Group by in collections

_Submitted via the Experts Hub:_

We need the ability to have a sort option for the Group by as well as the table contents.

We need this BADLY, and it's been asked for many times by clients and loads of experts.

Let's say we have a list of orders to fulfill. We might want to sort them by FIFO (first in, first out), which is all fine so far. But if there is urgency associated we want to group by urgency and sort by that group to show the highest urgency at the top. The problem is that once we sort by urgency we lose the sort by FIFO...which we still want inside of each group.

Other examples:

- sales groups by rep and sorted by date
- inventory grouped by order urgency and sorted by quantity remaining
- meetings grouped by category (alphabetically) and sorted by start time

...you get the point.

Ideally we just have the ability to have multiple sort options but I think the most critical is a sort by group and a separate sort by rows.