Grouped row with biggest number in another column to appear first?

jeszy

Assuming that I have a row grouping table which groups by browser and i want the browser that has the latest engine version to be displayed first. Is there any way to do it? I've tried a few variations and "cheats" by putting engine version before browser but it ends up being separated....

E.g. In the following scenario, instead of KHTML being on top, I would like for Trident to be on top since Trident has the biggest engine version (Internet Explorer 7) and Internet Explorer 7 will be at the top of Trident's group. Is this possible? Thank you

--------------------------------------
KHTML
--------------------------------------
Konqureror 3.1 KDE 3.1 3.1 C
Konqureror 3.3 KDE 3.3 3.3 A
Konqureror 3.5 KDE 3.5 3.5 A
--------------------------------------
Misc
--------------------------------------
Dillo 0.8 Embedded devices - X
IE Mobile Windows Mobile 6 - C
Links Text only - X
Lynx Text only - X
NetFront 3.1 Embedded devices - C
NetFront 3.4 Embedded devices - A
PSP browser PSP - C
--------------------------------------
Trident
--------------------------------------
AOL browser (AOL desktop) Win XP 6 A
Internet Explorer 4.0 Win 95+ 4 X
Internet Explorer 5.0 Win 95+ 5 C
Internet Explorer 5.5 Win 95+ 5.5 A
Internet Explorer 6 Win 98+ 6 A
Internet Explorer 7 Win XP SP2+ 7 A