Just want to do a simple group report like you would do in SQL. The result should look like this.
CATEGORY TOTAL
TEAM A 25
TEAM B 34
TEAM C 22
TEAM D 17
The standard grouping with the grid does not work. Too much detail and you have to open the group and scroll to get to summary. Is this example possible without using external view/SP?