moving difference

[Anonymous]

hi there,

ı need to calculate "moving difference" in a table, by expression or what ever.

ı have a table like that,

how can ı calculate the sales difference and sales difference by %

term	sales	sales difference	sales difference %
201710	429.461.964	-105.272.061	-19,69%
201709	534.734.025	8.759.702	1,67%
201708	525.974.323	6.334.298	1,22%
201707	519.640.025	29.041.695	5,92%
201706	490.598.329	-20.112.051	-3,94%
201705	510.710.380	23.725.775	4,87%
201704	486.984.606	-5.615.864	-1,14%
201703	492.600.470	32.737.748	7,12%
201702	459.862.722	-7.776.271	-1,66%
201701	467.638.993	-18.887.594	-3,88%
201612	486.526.587	23.837.553	5,15%

thanks for your helps.

[Anonymous · Accepted solution]

Hi,

supposed descending sort on month, try this :

sum(sales)-Above(sum(sales),-1)

and this for % :

sum(sales)/Above(sum(sales),-1)-1

[Anonymous]

i did this solution,

it worked.

but : in percentage calculating , with no "relative" check.

thanks my friend!