Creating decile report in OBIEE

Use Below formula to create decile reports in OBIEE

CASE 

WHEN RSUM(measure) / SUM(measure)*100  <=10 THEN

'0-10%'

WHEN  RSUM(measure) / SUM(measure)*100  <=20 THEN

'10-20%'

...

..

WHEN RSUM(measure) / SUM(measure)*100  <=20 THEN

'80-90%'

ELSE

'90%-100%'

END