4 Replies Latest reply: Feb 20, 2013 5:55 AM by Vishwaranjan Kumar RSS

    set analysis

      Hi ,

       

      my data looks like this

       

      date                    price

       

      1/02/2010              100

      5/10/2010               500

       

      6/01/2011               50

      7/09/2011               300

       

      8/02/2012              400

      7/05/2012              600

       

       

      Now i want output as

       

      Maxdate             Latestprice

       

      7/05/2012             600

       

       

      because among all dates 7/05/2012 is the maximum date and 600 is the corresponding price.

       

      But if select any year (eg:2010)

       

      output must be

       

      Maxdate             Latestprice

      5/10/2010              500

       

      . the latest price must show me the coresponding value of date(maxdate).