In Bex I have a query that list top N customers with their ranking. In the same query I have a column with these top N customers's ranking for the same period last year. I need the customers that fell of the top 20 ranking of last year. Ranking last year is between 1 and 20 and this year not. I've tried a condition that works looking at both rankings, but when I active the condition, I don't get the result I'm looking for and it changes the ranking.
If more than one condition is active, result rows shown will be only where both conditions are met.
Try the following:
- On current year rankings, display customers where ranking is greater than N.
- On previous year ranking, display customers where ranking in less than N.
With both conditions active, you should get customers who were in top N last year but not in the top N this year.