2 Replies Latest reply on Oct 8, 2018 11:28 PM by meenu choudhary

    Select Distinct rows

    Joseph Ong

      Hi,

       

      Seeking advice to select distinct rows in tableau.

      Here I have data and expected results shown below, I would like to generate the list of latest award each person received.

      Thanks all in advance.

         

      Data
      NameAwardYear of Award
      JohnOutstanding2016
      JohnInnovation2018
      MaryCreativity2018
      PeterIncentive2011
      PeterExcellence2013
      PeterOutstanding2017
      Expected Results
      NameAwardYear of Award
      JohnInnovation2018
      MaryCreativity2018
      PeterOutstanding2017