5 Replies Latest reply on Oct 29, 2018 2:11 PM by Shinichiro Murakami

    Finding Previous Months sales for selected month

    Radh Gowda

      Hi,

      Could anyone help me to find the solution for the below data (Please read the date as 'dd/mm/yyyy'):

         

      IdDateSales
      A1/10/2018100
      A1/10/2018150
      A1/9/2018150
      A1/9/2018200
      A1/8/2018100
      A1/8/2018200
      A1/10/201790
      A1/10/2017130
      A1/9/2017120
      A1/9/2017140
      A1/8/201780
      A1/8/201770

       

      My requirement is to display as below:

             

      ID2018-102018-092017-10
      A250350220

          

      Additionally when hover current month i.e.Oct 2018, it has to show 350(previous month i.e. Sep 2018 total sales ) on tool tip, when hover on Sep 2018 then it has to show it's  Previous month (i.e.Aug 2018) sales 300 on tool tip and  when hover on Oct 2017 then it has to show it's previous month (i.e Sep 2017) sales 360.

       

      Please do guide how to calculate the Previous months sales based on the month selection?

       

      thanks in advance.