Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this table:
date | X |
---|---|
12/2016 | 100 |
01/2017 | 200 |
02/2017 | 300 |
03/2017 | 400 |
04/2017 | 500 |
And the objective is :
date | X |
---|---|
12/2016 | 100 |
01/2017 | 100 |
02/2017 | 200 |
03/2017 | 300 |
04/2017 | 400 |
exemple: X= 200 - 100 ( 12/2016) = 100
X= 300 - 100 ( 12/2016) = 200
X= 400 - 100 ( 12/2016) = 300
Any suggestions please?
Regards,
Create a Straight Table
Dimension
date
expression
SUM(X)
IF(RowNo()=1,SUM(X),SUM(X)-top(SUM(X)))
make sure that you sort your table by date
Create a Straight Table
Dimension
date
expression
SUM(X)
IF(RowNo()=1,SUM(X),SUM(X)-top(SUM(X)))
make sure that you sort your table by date