slabwise analysis of customer performance
I have a sales cube, with dimension of customer, fiscal year, fiscal period ,sales revenue. I need to write a bex query, which give me number of customers, whose sale of the previous year was more than X $, lies between X & Y dollers, lies between Y & Z dollars like that, also with slabwise growth over last year , like this
Slab Number of customers Growth over last year %
> 1000000 5 20
> 500000 < 1000000 10 35
> 100000 < 500000 50 12
Please guide me with stepwise procedure to get such a result from BEX query.