Optimization tool - Solver usage in Alteryx

[jcastro]

Hello,  

Follow my case:  

When trying to transfer the use of the solver from excel to alteryx, I found that the Optimization tool would be the best choice, but even testing the tutorials and questioning other people I can't come up with a workflow that makes sense or even brings the expected result. All products must continue If the price X quantity has a percentage greater than 10% of the total, the quantity is adjusted to the point where the % stays at 10% with the objective of having the highest total value.   Here is the result in excel and spreadsheet:

Thanks!