6 Replies Latest reply on Jan 8, 2019 5:59 PM by Dinh Hoang

# Top N, Average N, Bottom N SalePersons

Hi!

I'm a newbie, I have a problem that needs people to help!

For example, I have 100 employees and would like to filter with rate (20:80): Top 10, Averger 80, Bottom 10.

How to do this? And use parameters or sets to be more flexible?

Looking forward to receiving your help soon!

Thanks

• ###### 1. Re: Top N, Average N, Bottom N SalePersons

Please help me understand - I get top N and bottom N - what is Average 80?

• ###### 2. Re: Top N, Average N, Bottom N SalePersons

Hi Jim!

I'm so sorry

Example:

I have 10 sellers:

I have given top 2 (1st and 2nd sellers) and bottom 2 (9th and 10th sellers)

And I want to give 3 sellers with average revenue from 4th person to 8th person?

It is difficult to describe

Thanks

• ###### 3. Re: Top N, Average N, Bottom N SalePersons

so in the view you want to see the names ans sales from the top 2 and names and sales from the bo0tom 2 ( individually ) and the average (a single number) of the rest?

JIm

• ###### 4. Re: Top N, Average N, Bottom N SalePersons

Yeah!

Example:

10 sellers / Sale DESC: 100 => 10

Top 2: 1st seller (Sales: 100), 2nd seller (Sales: 90)

Bottom 2: 9th seller (Sales: 20), 10th seller (Sales: 10)

Average 3: Average Sales: (80+...+30)/6 = 55 => 3 sellers: 40, 50, 60

• ###### 5. Re: Top N, Average N, Bottom N SalePersons

see attached

done with sets

top 2

bottom 2

values

labels

returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 6. Re: Top N, Average N, Bottom N SalePersons

Hi Jim

Thanks so much!

Top 2 and bottom 2 OK

But "Middle" I want to give 3 sub-categories which revenue has the most similar value to the average value (124864)?

Example:

Other 1: Sales = 124863 => "Middle"

Other 2: Sales = 124865 => "Middle"

Other 3: Sales = 124860 => "Middle"

...