ABC Analysis (revisited again!!!)

Hello Friends,

I saw few posts on how to do ABC analysis, but there were no concrete answers.

To summarize the requiement (say based on Good Receipt Quantities):

1. Top 25 -> indicate as 'A'

2. Bottom 25 -> indicate as 'C'

3. Records between 25 to 75. -> indicate as 'B'.

SAP How to paper(How to.. Realize an ABC Analysis) is on counts and not on cummulative %.

I used CKF, but it is only for display.

I used conditions, but it does not give the middle B records.

The last option would be VB macro, but then this would be not be a fantastic solution, as SAP Query can do ABC analysis, but BW Query would not be able to!!!

Regards

Pranay Dave