Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I have to make a straight table with 1 column showing Cumulative Difference.

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 -

WeekMonthQoe SubscribersCumulative Difference
Week1Jan230
Week1Feb252
Week1Mar22-3
Week1Apr308

Any help is appreciated. Thanks.

Deepali

2 Replies
sunny_talwar

May be this:

If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscriber], -Above(TOTAL [Qoe Subscriber])))

Silambarasan1306
Creator III
Creator III

This may be help you,

If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscribers] - Above(TOTAL [Qoe Subscribers])))