[DataGrid] Support row grouping and aggregation

[Janpot]

Summary

The Toolpad built-in DataGrid component should support row grouping.

• We should add a checkbox for "groupable" in the column definition UI, disabled? by default.
• We should add a checkbox for "aggregable" in the column definition UI, disabled? by default

Column definition UI:

Examples

No response

Motivation

No response

Search keywords: datagrid row grouping

[b4s36t4]

Would love to work on this.

What type of control prop I should be using to render the names of provided columns and how should I make the control multi-select. Should I need to be creating a new custom component here?

I took rowGrouping as the argType with default as [] i.e empty array but when I tried to render it rowGrouping is passed empty string is there any issue with assigning default value or somewhere it's getting overridden?

My current progress is, I was able to add the prop i.e Row Group model which accept an array of string and passing it to DatagridPro component.

Need some help here.

[Janpot]

@b4s36t4 I think we'd like to add options for groupable and aggregable in the existing columns component (see screenshot in issue body).