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.

  • Have you tried Sorting, Grouping and Total together under views? – SharePointer Apr 27 '17 at 9:25
  • Hi - I have tried this and many variations - all failed to achieve what i want. Do you have specifics by chance? – tim Apr 27 '17 at 20:43

Try this one


if you want to use DVWP follow this link: http://sympmarc.com/2009/05/20/showing-subtotals-in-a-dvwp-sorted-by-the-subtotals/

or you can try the following: How to Sort by Count

  • Hello Supermode - That formula didn't work. Do you think there's another approach other than utilizing a DVWP? – tim Apr 27 '17 at 20:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.