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.