I have a list that collects customer sales data (multiple records can contain the same customer). I am trying to create a view that will show the Top 5 customers based on sales. I need to have the customers grouped, and the sales data summed. Is there an OTTB way to accomplish this?

enter image description here

So I want to show the top 3 customers based on sales

  • 1
    What are the fieldtypes of your Sales info and What View with Grouping and Filtering have you tried? It helps to show screenshots of those settings in your question.. all I can answer now is Yes.. but.. – Danny '365CSI' Engelman Mar 22 '17 at 13:05

This is not possible OOTB since Aggregation has no sorting parameter. This might be because the values are never stored it is calculated on the fly. You can achieve this through some code. Have a look at this


You display item in batch of 3 items, you can set item limit in modify view setting.

You need to set item limit of 3 so each group will show top 3 data.

enter image description here

It will look like

enter image description here

It will display paging. If you want to remove that, just apply css over that.

To display top items, you can sort it by ID in asc in desc order.

  • That still does not sort the "Groups" (or in my case "Customer") by sales. I want the highest sales at the top. – MattC May 4 '17 at 17:13
  • @MattC you can sort it by sales field. – Rajesh Joshi May 5 '17 at 11:05
  • That is how my original screenshot is sorted – MattC May 5 '17 at 11:06

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.