Thank you Dimiter for the response.
I have all the data on the client side and not doing any operation on the server side. I have around 10k rows on the array so I will have to use virtual rendering.
After playing around with some of the settings you mentioned, I could get following working on the grid
- Loading the grid with an initial group
- Aggregate for each required column when grouped - I just needed to show count of items in each group
I am still looking for a way to implement following:
- When grid is grouped with multiple columns, header for each group level shows count of all the rows in the group. It will not consider the count of rows in the sub group. For example if parent group has 10 sub groups and each child group has 10 rows, it shows 100 as count for the parent group. I would like to change it to 10 since it has 10 subgroups.
- Collapse/expand button - if you can add this to backlog if not available as of now, that would be great too. I noticed that, if a group is collapsed and grid is scrolled all the way to the bottom and back - which re-renders all the rows, grid still remembers that the first group was collapsed. So I am wondering if there is a way to iterate over the groups and mark all of them as collapsed/expanded