Thanks. That works.
I have another dilemma though. I have different item options to add to the cart. I now have applied different discount rules for each item. It works well as long as I only add quantities of the same item. But once I add a different item, the discount from the new item is added to the previous item's discount. So if I have 35% off one items bulk order and a different item with 25% bulk discount, it applies 60% to the Grand Total. How can I limit each discount to each specific item only? I tried the following:
Condition: 'Quantity of a specific item in the cart'.
If the Quantity of item is (Here I put the ID of specific item).
Then the Calculation is based on Subtotal of column 'TotalPrice'.
I also used condition 'Number of items with a specific column value'.
As stated, works ok for one item but why does it add all the discounts together once I place other items with different discounts on basket?