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
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