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