3

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

Improve this question
1
  • 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
    Commented Mar 22, 2017 at 13:05

2 Answers 2

Reset to default
1

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

Improve this answer
0

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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