9 Replies Latest reply: Aug 9, 2015 4:27 PM by Digvijay Singh RSS

    Deduplicate and highest value in chart

      Hi,

       

      I have the following problem:

       

      I have a table with "Poliy_nr", "Loss_nr" and "Amount":

       

      The table is as following:

       

      Policy_nr         Loss_nr          Amount

      50899              1                        1.000           

      50899              2                        1.000 

      50899              3                        1.000 

      12987              1                        2.000

      12987              2                        2.000

      81790              1                        3.000

      81790              2                        3.000

      81790              3                        3.000

      81790              4                        3.000

      81790              5                        3.000

      13343              1                        4.000

      13343              2                        4.000

       

      I just want the highest "Loss_nr" in eacht "Policy_nr".

      The result must show the following:

       

      Policy_nr         Loss_nr          Amount

      50899              3                        1.000 

      12987              2                        2.000

      81790              5                        3.000

      13343              2                        4.000

       

      Hopefully somebody can help me how I can achieve this.

      I am struggling this problem for days without any success.