Not able to create percentile buckets dynamically

[Anonymous]

Hi Folks!!.

I have the following problem and I was wondering if you guys could help me.

Have table that contains attributes of store and revenue of each store, for example:

Store
Sku
Quarter
Class Desc
Urban
Revenue

Would like to show a funnel chart with dimension as Revneue_Bucket and measure as Avg_Revenue/Store.

Dimension:
Revenue_Bucket column should contain below buckets (Top 10%,10-25%,25-45%,45-70%,Bottom 30%).

Measure:

Avg Revenue/Store

When I select any Revenue_Bucket it should contain all the stores belongs to the bucket based on the Revenue/Store and this should be dynamic.

After that will draw the graph between the Buckets vs Avg Revenue/Store

Below is the approach i thought,

1.By using inline command create Revnue_Bucket dimension

2. Calculate Revenue/Store

3. To the Revenue/Store column would like to calculate the percentiles(Ex:Top 10%,10-25%,25-45%,45-70%,Bottom 30%).(this part am not able to do)

4.Draw graph between Revenue_Bucket vs Avg_Revenue/Store

Sample Data:

Store,Sku,Quarter,Segment,Class Desc,Urban Desc,Revneue
651,A1,2,Suburban - White / Mixed,DILUTABLE CLEANER,SUBURBAN, 11
8636,A2,3,Urban - White / Mixed,DILUTABLE CLEANER,SUBURBAN, 90
11657,A3,3,Suburban - Hispanic,BATHROOM CLNR,SUBURBAN, 50
8051,A4,3,Urban - White / Mixed,BATHROOM CLNR,URBAN, 3
7652,A5,2,Rural - Hispanic,DILUTABLE CLEANER,RURAL, 7
9342,A6,3,Rural - White / Mixed,BATHROOM CLNR,RURAL, 30
2705,A1,3,Suburban - White / Mixed,DILUTABLE CLEANER,SUBURBAN, 27
11063,A7,1,Urban - African American,DILUTABLE CLEANER,SUBURBAN, 25
1091,A8,3,Urban - Hispanic,WIPE CLEANER,SUBURBAN, 3
6026,A9,3,Suburban - African American,SPRAY CLEANER,SUBURBAN, 8