This is a migrated thread and some comments may be shown as answers.

possible to sort by aggregate value (descending) when grid is grouped?

1 Answer 182 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Tim R
Top achievements
Rank 1
Tim R asked on 10 Jul 2013, 05:32 PM
Let's say employees are choosing health insurance plans, and as part of that process, they can ask the application to show how many of a particular kind of doctor can be found in their general location. They want the application to rank the results in descending order (most to least) while continuing to show the locations (by zipcode) where these doctors can be found.

At first the grid would be displayed without any grouping; the employee trying to decide between health insurance plans would drag the plan name column header up to the grouping panel, in order to produce the listing shown below.  NOTE: At present the insurance plans are being sorted alphabetically  when the grid is grouped by Plan-Name:

Gold
Platinum
Silver

Can the grid be made to sort as shown here, i.e. by SUM(DOCTORS) DESCENDING?


PLAN-NAME.................ZIPCODE....................DOCTORS
Platinum
................................................10045.........................................7
................................................10047.........................................12
................................................10050.........................................3
                           TOTAL DOCTORS.........................................22


Gold
................................................10044.........................................4
................................................10048.........................................2
................................................10052.........................................3
                           TOTAL DOCTORS.........................................9


Silver
................................................10041.........................................2
................................................10042.........................................2
................................................10055.........................................1
                           TOTAL DOCTORS........................................5

1 Answer, 1 is accepted

Sort by
0
Petur Subev
Telerik team
answered on 12 Jul 2013, 11:55 AM
Hello Tim Romano,

I understand your requirements, however I am sorry to say that the Grid does not provide you with such sorting/grouping behavior.

I could suggest you to share the idea on the feedback portal and if more people vote for it we will consider to add support for such behavior.

Kind Regards,
Petur Subev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Tags
Grid
Asked by
Tim R
Top achievements
Rank 1
Answers by
Petur Subev
Telerik team
Share this question
or