Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
input:
| Month Year | Sales |
| Jul-19 | 23 |
| Jun-19 | 44 |
| May-19 | 444 |
| Apr-19 | 11 |
| Mar-19 | 85 |
| Feb-19 | 48 |
| Jan-19 | 949 |
| Dec-18 | 48 |
Required Output:
| Month Year | Sales | Output |
| Jul-19 | 23 | 1652 |
| Jun-19 | 44 | 1629 |
| May-19 | 444 | 1585 |
| Apr-19 | 11 | 1141 |
| Mar-19 | 85 | 1130 |
| Feb-19 | 48 | 1045 |
| Jan-19 | 949 | 997 |
| Dec-18 | 48 | 48 |
Perhaps this?
If(RowNo(TOTAL)=1, Above(Sum(TOTAL Sales),0), Above(Sum(TOTAL Sales),0)-Below(Sum(Sales),0))
Thanks for your response, other dimension and order in data that's why i am not getting correct output