Required Sorting on Grouped Column Value

[Nagendra Gupta]

Hello Team,

I am using groupSettings in Grid, and I want sorting on behalf of Group By Column Sub Total Value.

Please see attach snapshot, I want sorting data on selected value

Attachment: WhatsApp_Image_20210914_at_5.36.13_PM_bc34109c.zip

[Sujith Kumar Rajkumar]

Hi Nagendra, 

 

Greetings from Syncfusion support. 

 

Based on the query we could understand that your requirement is to sort a column on grouping based on its calculated aggregate group caption value. We would like to let you know that the Grid grouping is performed by using the whole column’s data source value which will be sorted in ascending order(by default) if no sorting has been applied for that column and if sorting is applied before grouping, then the same sorting order will be maintained in the group. So consecutive sorting will only occur within the groups. Also, the sort/filter action in the Grid is performed only on the Grid rows and not on the aggregate rows. This is the default behavior of the Grid’s grouping and sorting functionality. 

 

If we misunderstood your query or if you require any further assistance, then please get back to us. 

 

Regards, 

Sujith R 

[Nagendra Gupta]

Hi Sujith,

Thanks for you kind reply.

You right understand my requirement.

My requirement is just want to sort calculated aggregate group caption value  with their child grid rows. How to achieve this.

[Sujith Kumar Rajkumar]

Hi Nagendra, 

 

As mentioned in our previous update, the Grid actions like, grouping, sorting, etc., will be performed based on the Grid’s data source. So when the grouping action is performed the data source will be sorted in ascending order(by default) on the grouped column if no sorting has been applied and if sorting is applied before grouping, then the same sorting order will be maintained in the group. And consecutive sorting will only occur within the groups. 

 

This is the default behavior of the Grid’s sorting functionality and it is not feasible to perform the sort action on the calculated aggregate values. 

 

Regards, 

Sujith R