I have a SharePoint list. It contains data such as:
Name - Topic
John - Topic1
Bob - Topic2
Bob - Topic3
Bob - Topic4
John - Topic2
Dave - Topic1
I want my list to be sorted like:
Bob 3
John 2
Dave 1
Sorted by greatest number of items on top connected with name inputted.
I have tried all methods I can think of including Group By -- With group by, i can't sort from largest number of items.
I feel like a count formula or countif may be the solution...but i can't figure out the correct way of incorporating it.
I am looking for a solution to this without having to go in back end and write code. I am find with implementing script web part if needed, but that's as technical as i'd like to go.
Is this possible without going in back end?
Thanks - i really appreciate it.