How to calculate running sum and create buckets

[farheenayesha]

Hi,

     I want to calculate running sum for accounts and also create buckets using running sum % values as below. Please help me to correct formulas

1. Running sum of sales: i have used below expression to calculate it.

          RangeSum(Above(sum(SLS_AMT),0,RowNo()))

2. Running sum % :

           RangeSum(Above(sum(SLS_AMT),0,RowNo()))/sum(TOTAL SLS_AMT)

3. Segments :

          if(Running sum % <=0.2, 'Top 20%',

                 if(Running sum % >0.2 and Running sum % <=0.4 , 'Middle 20%','Bottom 40%'))

Using the above buckets i want to create a bar chart as below. Please help me to create the below bar chart.

[farheenayesha]

Yes correct

[sunny_talwar · Accepted solution]

Not exact, but very close...

[farheenayesha]

Bottom 40% is showing exactly correct values, however other two requires little corrections.

I really appreciate your efforts to get the solution. Thank you so much Sunny. You are great