Top 8 Customer

[Learner09]

Hello All,

I am trying to pull out the Top 8 customers on the basis of USD and Sales. Could anyone please assist? I attached the sample data.

[ShankerV]

Hi @Learner09 

One way of doing this.

[Learner09]

@ShankerV thank you. I need the top 8 customers in USD.  pls, see the below example of what I am looking for -

[ShankerV]

Sure, I see you have done the sum and then filtered top8

Possible 1 min.

[DavidSkaife · Accepted solution]

Hi @Learner09 

Here you go

[ShankerV · Accepted solution]

Hi @Learner09 

Please find the expected solution.

[grazitti_sapna]

@Learner09 , Here is what I have. Please try out and let me know if it helped:

[RobertOdera]

Hi, @Learner09 

It is not as straightforward as it sounds:

• not all customers will be in the top 8 for both sales and USD
• law of large numbers suggests some customers might (one day) have the same sales or USD or both, i.e., the same rank

Please see the below.

Please mark it as an acceptable solution if it works for you.

Cheers!

[apathetichell]

@Learner09  there are lots of great answers here for your question - but if you are going to learn Alteryx - this is a great starter workflow to take a jab at yourself... don't know how to summarize values? try this lesson:

https://community.alteryx.com/t5/Interactive-Lessons/Summarizing-Data/ta-p/424417

And what about how to choose your top ranked entries? Well there are a whole slew of different approaches. Most of us would use the sample tool - after sorting. Someone else might use RecordID and a Filter - there's no correct way.

https://community.alteryx.com/t5/Interactive-Lessons/Sampling-Data/ta-p/85807