Percentile / Decile Basics

building reports desktopintelligence
1

Hi everyone. I’ve come across a report requirement which may be simple for most of you but complex for me. Any help would be greatly appreciated.

I have to create a report with Deciles / Percentiles. My columns should be DECILE, CUSTOMERS (count of CUST_ID) and REVENUE (a metric)

The customers should be broken into 10 groups (or deciles) based on their contribution to total REVENUE. So decile 1 would be top 10% customers, decile 2 would be top 10% - 20% and so on… 10 groups / deciles / percentiles.

I will try to add screen shots later.

Thanks!

twenty5 (BOB member since 2008-01-22)

2

what database are you using ?

If oracle look into NTILE() analytic function… this should help you.

BO_Chief :us: (BOB member since 2004-06-06)