2 Replies Latest reply on Aug 17, 2016 9:05 PM by Sanket Deshpande

    Count of Members with Maximum Score

    Sanket Deshpande

      Hi all,

       

      I have a requirement. the format of data is :

       

         

      MeasuresNamew                                                                                        Score
      asam13
      amam23
      ajohn42
      amike23
      aharvey23
      adonna42
      blouis42
      brachel65
      bjessica65
      bharold65
      beshter7

       

       

      and the required output is

       

      Measure      max.value         no.of count

       

      a                    42                         2    

      b                    65                          3

       

       

      Kindly suggest solution for the same

       

      Thanks and regards,

      Sanket