List pagination with group by

[paulproffitt]

I have a list that is defined with a group by on one column in the list (happens to be a user_id). When the list is displayed with pagination enabled, it seems the group by is being applied after pagination rather than before.

So if records per page in pagination are set to less than the entire list, then group totals are incorrect in that they show the number of records on the page for that group rather than the number of records in the list for that group.

How might be the best way to group the list's query prior to pagination so that the group counts are correct?