Skip to Content
avatar image
Former Member

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

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)...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers