Cummulative sum with buckets in the dimension

[Anonymous]

How to build a logic for "cumulative sum "with buckets in Dimension in a tabular report 

Dimension : [PAID RANGE NEW]

Measure : amount

Below is the inline table i created in the data load editor

paid_period_12group:

Load * inline

[paid_period_id_new, "Paid Range New"

1,'>$500M'

2,'$500M - $100M'

3,'$100M - $50M'

4,'$50M - $10M'

5,'$10M - $1M'

6,'$1M - $500K'

7,'$500K - $400K'

8,'$400K - 100K'

9,'$100K - $25K'

10,'$25K - $2500'

11,'$2500 - $100'

12,'$100 - $0'

13,'<$0'

];

TIA

[Anonymous]

Hi Youssef,

Can you please tell me the calculation by not converting the data and by using the amount field,

Thank you.

[Anonymous]

Hi Omar,

I didnt link amount to paid_range_new and I tried by not putting the amount values manually and it didnt work.  Can you please share the qvf for better understanding,

Thank you.