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

    Calculation previous day

    amir ohev shalom


      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