Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my table, I have week, month, No of QOE Subscribers.
I have to create a new column, and place cumulative difference of the QoE Subscribers in that column. Also, the first row should be null (0) and the cumulative difference should start from the 2nd column.
Ex -
Week | Month | Qoe Subscribers | Cumulative Difference |
---|---|---|---|
Week1 | Jan | 23 | 0 |
Week1 | Feb | 25 | 2 |
Week1 | Mar | 22 | -3 |
Week1 | Apr | 30 | 8 |
Any help is appreciated. Thanks.
Deepali
May be this:
If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscriber], -Above(TOTAL [Qoe Subscriber])))
This may be help you,
If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscribers] - Above(TOTAL [Qoe Subscribers])))