3 Replies Latest reply: Mar 7, 2016 7:24 AM by Sunny Talwar RSS

    Using expression within a table to find the max of a value

    Patrice Veasey

      Hi all.

       

      I have a table with the headings "Proposition", "Nominee" and "Nominator".

       

      Nominee and Nominator contain a list of names for each of them.

      What I need to do is to write an expression for both Nominee and Nominator that will show the name of the Nominee and Nominator who appear most in the data set, for each proposition.

       

      For example:

       

      Proposition: Techonology

      Sally appears 5 times as Nominee, John is mentioned 4 times

      Bob appears 7 times as Nominator, Fred is mentioned 10 times

       

      The table should look like the following:

       

      Proposition     Nominee     Nominator

      Technology     Sally          Fred

       

       

       

      Thanks in advance for your help.