Add grouping to the List screen including totals of some of the columns

This requires you to update the values on the screen because of the change

The Sortable columns still retain Entity + Attributes

Since grouping gets added, the sortable columns don't get updated. We have attempted to update the sorting based on the Executed SQL but it isn't working. Users are getting an error about the sort column no longer included in the Group by. We are having to consider changing it to an advanced query.

Idea

It would be nice to have an update on the sortable column to

Make it more intuitive on how to select which columns to sort on rather than having to go back to "advanced query" syntax. Maybe a drop down?

If you are grouping data in aggregate and there is a screen expression, have an auto-fix for expressions and column references on the screen.