8 Replies Latest reply: Jun 24, 2014 12:24 AM by jagan mohan rao appala RSS

    Get maximum value

      Hi all,

       

      I have a question regarding the following conditions:

       

      I have a table:

      LetterApr-14May-14Jun-14Jul-14Aug-14Sep-14
      A100200300400500600
      B100200300400500
      C600700800900

       

      I need to create a table where I have to output the latest value (latest value is base on Letter (A<B<C<D,.....)

       

      The output should be:

      Apr-14 [A]May-14 [B]Jun-14 [C]Jul-14 [C]Aug-14 [C]Sep-14 [C]
      Qty100100600700800900

       

      How do I achieve this? Please take note that my selection of letters can differ. I select A and C it should output something like this:

       

      Apr-14 [A]May-14 [A]Jun-14 [C]Jul-14 [C]Aug-14 [C]Sep-14 [C]
      Qty100200600700800900

       

      The month selected also changes. How to achieve this? How can I only get the latest value?

       

      Thanks in advance!