4 Replies Latest reply: Nov 15, 2016 10:33 AM by jeevayswaran a RSS

    get sum of values of first date of each month

    jeevayswaran a

      Hi frds,


      Date               MonthYr           Amonut

      1-Jan-2016        Jan-2016          10

      2-Jan-2016       Jan-2016            20

      5-Feb-2016       Feb-2016          30

      3-Feb-2016       Feb-2016           40

      3-Mar-2016       Mar-2016          50


      Above is my data.


      my expected answer is:


      MonthYr     Amount

      Jan-2016     10

      Feb-2016     40

      Mar-2016     50


      The output is based on first date value of each month, if i select a date the month should appear minimum date month to maximum date month. for example if i select 5-Feb-2016 in date field the result is,


      MonthYr     Amount

      Jan-2016     10

      Feb-2016     40


      please suggest me.