I have a field called 'UserID' and another field called 'RoleName'
Each UserID can have up to eight different values for 'RoleName;
For example, UserID 123456 can have a RoleName of Platinum, Elite Gold, Elite Red, Gold, Red, Silver, Bronze and Blue. However, Platinum is the highest in terms of ranking of these.
My end goal is to be able to have a chart or similar that shows an accurate number of UserID's in each RoleName. UserID 123456 is Platinum, but by virtue of the data, the UserID may show up in any of the seven other roles, but I only want it to be counted for Platinum, which is the highest.
Ideally, I would like to do this in the script. Looking for suggestions. Thank you.