Group on multivalued column
We have a list that holds the names of our projects and associated metadata... Things like "Project Manager" (user column) and "Team Members" (multi-valued user column).
We have a view that groups the projects by "Project Manager". We've had many requests for the matrixed team managers to have views for their own teams, too, grouped by their direct reports... but their team members are all added to a multi-valued column, so we can't group on it... we can only filter on it.
Adding new columns for every team the matrixed resources come from isn't realistic, especially because most projects have more than one team member assigned.
Having a view grouping on a multivalued field and replicating the rows for every member they apply to based on the filter applied to such a view would be grand!