Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the below straight table in my app
ID | Sales |
1 | 100 |
2 | 200 |
3 | 300 |
4 | 400 |
5 | 500 |
Looking for set analysis expression and would like to see the below result in straight table.
ID | Sales | New Column |
1 | 100 | 100 |
2 | 200 | 300 |
3 | 300 | 600 |
4 | 400 | 1000 |
5 | 500 | 1500 |
As you can see the 'New Column' field is taking the sum of their respective above rows. Looking for set analysis expression to achieve it.
Regards,
Vikas
RangeSum( Above(Total Sales,0,5) )