2 Replies Latest reply on Oct 10, 2018 4:42 AM by Anindam Das

    Percentage different between selected and corresponding previous month 10.2 version

    Anindam Das

      I have a data set as below.My requirement is user can select a specific year and then specific month of the year using filter

      I have to show Sales variance = (sales of selected month - sales of previous month) /(sales of selected month).

        

      CompanySales                Date
      Tata40010/1/2018
      Tata3009/20/2018
      Tata2008/21/2018
      Tata1007/22/2018
      Birla40010/1/2018
      Birla3009/20/2018
      Birla2008/21/2018
      Birla1007/22/2018
      Tata40010/1/2017
      Tata3009/20/2017
      Tata2008/21/2017
      Tata1007/22/2017
      Birla40010/1/2017
      Birla3009/20/2017
      Birla2008/21/2017
      Birla100

      7/22/2017

       

      so if the user selects Year 2018, Month October then output will be

       

      CompanySalesSales Variance
      Tata 4000.25
      Birla4000.25

       

      Sales variance  = 400-300/400 =0.25

      As for 2018 october sales is 400

      for 2018 september it is 300

      Kindly help .I am using 10.2 version .I have attached the workbook also