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!