Sort by collapsed fields

[Erich_Sagers]

Is there a way to sort by the count field after you’ve applied a grouping? I have items that are grouped by sales reps and the grouping header gives me a count and I want to sort the groups by count.

[Jeremy_Oglesby]

That’s why I said you have to actually group first on the “Total Score” Field - in the grouping menu, you can choose how the groups are sorted, so tell it to sort the score groups from highest to lowest.

[David_Albert-Le]

Thanks Jeremy, that’s great.
Turns out you can’t actually group by a formula field, who knew? I just duplicated it and turned it into a regular number field. Check it out:

Screencast.com

Sorting_airtable.swf

Shared from Screencast.com

Now just need to isolate top three somehow. I can manually check them off using a check box field, but then it messes up your beautiful method.
Thanks again for all your help!

[Steve_Ruqus_ECT]

Don’t forget a Pivot Table App. I use it to sort when I don’t have links like when I import eCommerce Data from another system. P.S. we need something that mimics the lookup or index match functionality of a spreadsheet for this same reason. I don’t always have nicely structured data (links/lookups).