...
You can also group your dataset by dragging-and-dropping column headers into the “Group By Box” above the datagrid to pivot your view of the data almost any way you want to see it.
Calculated Footer Fields
View calculated values in the footers of your columns by Sum, Min, Max, Count, and Average
Right-click any field in the footer.
Select one of the available options.
...