3 Replies Latest reply on Mar 2, 2017 9:16 PM by gopi duppati

    Need to calculate the previous values based on Month and year

    Rakesh Cherukuri

      Hi Guru's,

       

      I have an interesting question, as I have a requirement stating that they need the MTD calculation based on the current year and current month, as they want year and Month as 2 separate filters and single select for both.

      ex:  I have the below data, so when we select  year as 2016 and month as 11 then we need to sum the prior months in 2016 as Months to date value(8+9+10+11)

       

      if I select year as 2017 and month as 3 then I need to add 1+2+3, so it is year specific, I had attached the sample data excel.

       

      YearMonthPremium Amt
      2016890
      201691
      2016102
      2016113
      20161254
      2017144
      2017248
      2017377
      2017488

       

      Appreciate the help. Thanks in advance