3 Replies Latest reply: Jun 1, 2015 2:20 AM by Ramesh A RSS

    Finding values in one field, which is associated to maximum value of another

    Ramesh A

      Below is the Data:

       

      ContactLocationCalls
      ConA2
      ConB1
      Con1A1
      Con1B1
      Con2B2

       

      I want number of calls per contact based on minstring of location'.

       

      Output:

       

       

      ContactLocationCalls
      ConA2
      Con1A1
      Con2B2