6 Replies Latest reply: Aug 4, 2011 2:23 AM by asnajim2000 RSS

    last value

      Hi,

       

      I have the following data and was wondering what is the best approach to collect the last value...

       

      value, date

      1532.00, 29/01/2010

      1560.00,31/01/2010

      1590.00,17/9/2010

      1420.00,30/12/2010

      1500.00, 29/01/2011

      1300.00,31/01/2011

      1990.00,17/9/2011

      110.00,30/12/2011

       

      what I am looking for, is while doing the chart, and in case the year selected ... then I should show the values related to last value of each year, and if months selected then the same thing to show the last value of each month ....

       

      any help