1 2 Previous Next 16 Replies Latest reply on Sep 12, 2017 10:01 PM by John Matthew

    selecting a period(selection across months) and comparing values in the same period for the last 10 years

    John Matthew

      I have a requirement like:

      select a period over different months as in ---15th March to 20 May 2017 and display the sales value corresponding to this.

      and compare the sales value  with similar periods for the last 10 years as in  15th March to 20th May 2016, 15th March to 20th May 2015,15th March to 20th May 2014 and so on till 2007. So my data should look like this:

       

       

      Period                                                                               Sales
      15th March to 20 May 2017123
      15th March to 20 May 2016123
      15th March to 20 May 2015342
      15th March to 20 May 2014324
      15th March to 20 May 2013235
      15th March to 20 May 2012432
      15th March to 20 May 201123
      15th March to 20 May 2010543
      15th March to 20 May 2009345
      15th March to 20 May 2008654
      15th March to 20 May 2007345

       

       

      Can somebody please help

        1 2 Previous Next