1 Reply Latest reply on Jun 5, 2012 6:04 AM by Sourabh Dasgupta

    Maximum value for a name?

    Will Perl

      My data consists of a large number of records with a name and a number of games played. Is there a Calculation/group/filter I can make that will give me only the largest number of games for each name? Sort of like doing a SQL Group By, but with the maximum games

       

      Example Data:

      Name | Games

      John   |   3

      Mike   |   7

      John   |   9

       

      I want to just get:

      Mike   |   7

      John    |   9

       

      If the answer is obvious I'm sorry, but I've been trying to figure this out for a while now and can't seem to get it. Thanks!