Discounts by specified price, not percentage
I'm not seeing info specific to this, but maybe it's easy to address. I have a client with an existing database of product. Within their primary category of product (boxes of moulding), they have different prices based upon the total number of boxes you purchase. I see a straight forward way in which to set a rule for a discount based upon the box total, but it appears that allows me to set a percentage discount. Rather than a percentage, I need it to use column:PriceA (unique to each product) if the order is 1 to 4 boxes, column:PriceB (once again unique to each product) if the order total is 5 to 8, and so on.
Is there a relatively simple way to do that rather than a percentage discount?