1 Reply Latest reply: May 20, 2015 4:55 AM by Gysbert Wassenaar

# Calculation previous day

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