Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sum(sales) - above(sum(sales))
sum(sales) - above(sum(sales))
thanks dear Greeshma