Help

Re: Sorting after grouped

5033 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Erich_Sagers
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

12 Replies 12

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.

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:

e167077d87db3c0baee405dd2edbf42e894f84ed.gif

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
4 - Data Explorer
4 - Data Explorer

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