4 Replies Latest reply: Feb 11, 2014 5:41 AM by Ashwani Kumar RSS

    Create field by peeking the last value of Every month .

      I have data like this:

       

      Value       date

      120           1/1/2013

      12              31/1/2013

      122           31/1/2013

      123             1/2/2013

      132            15/2/2013

      234            30/2/2013

      13             30/2/2013

      144           30/2/2013

      126             1/3/2013

      13                31/3/2013

      313               31/3/2013..

      Now i need to create a field in back end which shows me values ie.. 122, 144,313. which are the last value of the month.Please help me ...