Is there a way to do multi-tier pricing

My client has multi tier pricing structure where essentially a customer can have more than one customer price class. So how it would work is Customer A, Item A could have Tier 1 = $100, Tier 2 = $90. The sales price would be the minimum price so the system should automatically select 90. I’ve tried using Sales price worksheet but no luck because a customer can only have customer price class and I’ve tried using the alternate ID as a tier category but it errors out because of the same active date range. Any ideas?