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.

       

      Thanks,

       

      Jesse