help rank data

Hello Community,   I need to categorize a visual by the below:    Black / platinum is the 5% of the entity with highest spend Gold is top 20% to top 5% Silver is top 50% to top 20% Bronze is b...