1 Reply Latest reply on Dec 19, 2017 2:21 PM by Shinichiro Murakami

    Retrieve user using max value

    Jesse Narang

      Hello Tableau Community,


      I have a simple table that looks like below:


      Basically, my table consists of AID, PID, Rep, and Revenue. A PID can have multiple AID's and AID's are managed by different reps.

      I am trying to assign just one owner to a PID based on the count of AID's. i.e any given rep who owns the max number of AID's within a PID should be the owner of that specific PID


      If all reps have the same count then whoever has more revenue owns the PID


      Is something like that possible?


      I have attached the workbook also.