Last Updated: 30 Sep 2019 09:11 by ADMIN
Tim R
Created on: 12 Jul 2013 14:16
Category: Grid
Type: Feature Request
Feature to rank groups (sort them relative to each other) by an aggregate value
My users ask for this in almost every application.  When a grid is grouped, the users want to see the groups in an order that indicates some ranking by an aggregate value. For example, If SALES-DETAIL table is grouped by SALESPERSON, the default alphabetic order of the groups might be AMELIA, BARBARA, CARLOS, DAVID, HARRY, THOMAS, ZELDA. But users want to see the groupings in descending order by the salesperson's TotalSales, which might be HARRY, ZELDA, AMELIA, THOMAS...etc. So we need a way to specify a custom-group-sortorder. And to be perfectly clear, that is the sequence of groups with respect to each other, not the order of detail data inside the group. The detail records might be sorted chronologically by SalesDate regardless of the order of the group relative to each other. In SQL the equivalent would be  ... GROUP BY SALESPERSON ORDER BY SUM(TotalSales) DESC(ending). This feature would work hand-in-glove with another requested feature, showing the group footer when the group is collapsed.
1 comment
Alex Hajigeorgieva
Posted on: 30 Sep 2019 09:11


I am pleased to let you know that this feature is available as the data source group compare property since R1 2019:

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.