Through this features, users can interactively organize their data in a way that suits best their needs with a single drag and drop action. To empower users to get more value from their data RadGridView provides aggregates display that calculate values taking into account every data item in the group. You can add a variety of aggregate functions, such as Sum, Count, Min, Max, Average, etc, to your data model and see the results they produce in the RadGridView.
Data can be grouped according to several criteria effectively creating a tree of groups with the leaf nodes holding the actual data records. Users can group data by dragging a column header and dropping it in the group area above the RadGridView control. Users can also rearrange the grouping headers in the group area (again by dragging and dropping).

Advanced filtering
RadGridView features a customizable filtering, allowing you to define your own filtering descriptions. Furthermore, the control offers Excel-like UI letting users to quickly pick a filter value.
Aggregates
Aggregates display calculated values taking into account every data item in the group. You can add a variety of aggregate functions, such as Sum, Count, Min, Max, Average, etc, to your data model and see the results they produce in the RadGridView. Of course, in the spirit of WPF, aggregate result display is fully customizable.