Sort Grouped View by Count?

I'm trying to sort a grouped view in order of the groupings with the most records. (I need to prioritize where to spend limited resources and this will help greatly). 

In my speaker database going back 25 years, some speakers have appeared 10+ times, others only once. Here's a shot of the grouped view. How do I sort by count, largest to smallest? 

Talks grouped by speaker.jpg 

And if you can think of a different way to sort by count (instead of using a grouped view) I'm all ears!
Thanks. 

 

Solved Solved
1 5 358
1 ACCEPTED SOLUTION

Yep. Check out COUNT() and SELECT() for both.

View solution in original post

5 REPLIES 5
Top Labels in this Space