measure for the previous dimension value

[#1]

Hello

i have a table which shows sales measure for each Week Id. now i want to have another column which shows the increase from previous week; something lie this:

Week Id	Sales	Increase
1	20
2	23	3
3	30	7
4	25	-5
5	30	5

How Should i set the expression?

Regards

Mana

[Anonymous · Accepted solution]

sum(sales) - above(sum(sales))

[#3]

thanks dear Greeshma