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
