Please help me understand - I get top N and bottom N - what is Average 80?
I'm so sorry
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
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?
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
done with sets
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.
top mid and bottom.twbx 2.3 MB
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)?
Other 1: Sales = 124863 => "Middle"
Other 2: Sales = 124865 => "Middle"
Other 3: Sales = 124860 => "Middle"