CUMULATIVE SET ANALYSIS EXPRESSION

[souadouert]

HELLO;

i have straight table  ,contains two clomun , value per month , so i want to create new table with the difference between two months

Thank u

[sunny_talwar · Accepted solution]

Try this

RangeSum(Expression, -Above(Expression))

[Digvijay_Singh]

Do you have same dimension in the new table. You need to use Above function for this.

If you have Month and value columns, then use Sum(Value)-Above(Sum(Value)), The first value may show null as there is no above value to that, You can surround it with Rangesum or Alt functions to show same column value or 0.