Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table (CHART) Conclusion with distribution dates.
I would like to add another measure that shows me the figure of the previous day how can I do this?
itd look like this:
date 20/5 19/5 18/5
(sum(count)) (sum(count)) (sum(count))
1 X Y Z
2 X Y Z
3 X Y Z
and that what i want:
date 20/5 19/5 18/5
(sum(count)) sum(yesterday) (sum(count)) sum(yesterday) (sum(count)) sum(yesterday)1 X Y Y Z Z B
2 X Y Y Z Z B
3 X Y Y Z Z B
Thanks in advance
Try using the after() function: after(sum(count)).