Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

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


Thanks in advance

1 Reply
Gysbert_Wassenaar

Try using the after() function: after(sum(count)).


talk is cheap, supply exceeds demand