Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

slabwise analysis of customer performance

Dear all

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.

Not what you were looking for? View more on this topic or Ask a question