1 Reply Latest reply on Mar 28, 2018 8:24 AM by Deepak Rai

    Current day sales vs same day last year upto same hour

    thomas.lyon-shaw

      From a previous discussion where I was kindly assisted by Tushar in resolving the answer to the subject line, I have since applied this to my view and noticed that it is displaying the data for the same DATE value last year and ideally, I could do with it displaying the same DAY last year. Today is Wednesday 28th March 2018 and I need the calc to return data for Wednesday 29th March 2017.

       

      This was the resolution provided in my first discussion and I now wonder if anyone can assist in changing this for the desired outcome?

      And I adapted it for use in my sheet as follows

      I have attached some sample data 01/03/17 - 31/03/18

       

      Thanks

       

      TLS