2 Replies Latest reply on Apr 11, 2018 9:52 AM by Andy UK

    Week on Week Advanced

    Andy UK

      Hi

       

      My data starts 01/01/2018.

       

      I'm using a table to show week-on-week increase in sales eg:

       

      Week Commencing / Sales / % Increase

      26/03/2018    100  

      02/04/2018     110 10%

       

      To do that I've had to select two weeks. Is there a way of selecting just one week (02/04/2018) to get the same result (i.e. still seeing 10% increase?)

       

      Alternatively, selecting 2 weeks and then hiding the first week (26/03/2018) and still seeing 02/04/2018 and the 10% increase?

       

      Thanks

       

      Andy