Cumulative total for relative value

[lord_zeus]

Hello, everybody!

Im try to calculate a relative value for chart visualisation where dimantion in days spend (0,1,2 etc)

Problem: in component of formula i need a cumulative total by my dimantion. 

I'm make some example:

Im wont get chart like this

the problem is that I cannot use the previous values ​​for the calculation. I need to take a measurement and count less than the current in a variable or in SetAnalysis

[Kushal_Chawda · Accepted solution]

may be this

=(rangesum(above(total sum({<ID>}OUT),0,RowNo(total)))/rangesum(above(total sum({<ID>}IN),0,RowNo(total))))*avg(1)

 Where ID is the X-axis Dimension

[lord_zeus]

Thenks, its work.

Im make a reference table and add it to model with references to main table. Im need it becose my formula with count(distinct id) ... so im need to calculate unicu id in each row...