AgGrid: How to have multiple rowGroups without forcing them to the left and a sum column in...

I'm working with AgGrid, and I want to achieve the following column layout and behavior:

• Have a rowGroup on one column (e.g., "Category")
• Then a regular column that shows the sum of Quantity (aggregated by the grouping)
• Then another rowGroup on a different column (e.g., "SubCategory")
• Crucially, I want to keep the order of these columns as declared — so the first rowGroup stays where it is, the sum column stays in the middle, and the second rowGroup stays after it.
• I do not want the two rowGroups to be forced to the left side of the grid, as AgGrid normally moves grouped columns to the left automatically and hides the original grouped columns. Is there a way to configure AgGrid so that multiple rowGroups can be displayed inline in the grid without moving them to the left, and still be able to show an aggregation column like sum of Quantity between them?

Thanks in advance!

Continue reading...