How to adjust price based on sales amount

Summary:

For Item A the general price will be 100

But if sales order amount more than 10000 per SO in total, the price will be 90.

So if we got one sales order: Line 1 ItemA, 10 ea,Line2 item B, 10 each. SO total amount is 12000, the unit price for Item A should be 90

Can we set some discount based on this scenario?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):