Skip to Content
0

SAP Query separate listed customers in 3 even sized groups according to sales

Aug 26, 2017 at 12:08 PM

39

avatar image
Former Member

In a query the list of customers is displayed in the rows with the sales amount. They are supposed to be grouped in 3 equal sized groups according to the sales amount. Then every customer is to be compared within its Group if it is above or below average.

How do you get 3 equal sized Groups for the comparison? I find Top N ranking does not work, because i do not know the number of customers to be displayed in rows before query execution (therefore not know how many to be listed as "N" for Top N) and the Top % does not work, because Groups will not be equally size, but depending on sales amount (therefore one Group might have 5 customers, whereas the others have 100 or 380)...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers