Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis challenge took me a fair bit of time but I really enjoyed it! I haven't used the optimization tool before, so it was great learning how to use it!
I made a macro that returned the optimum $ based on user input box weight and number of boxes.
Here is my solution. Workflow for finding unique combination of items took time. Thereafter, was able to achieve example output quickly.
This was a fun challenge; lots of different answers and methods posted. Very cool.
I think the most difficult part is finding the non repeating combinations.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Cross-Tab/ta-p/4368
check the above article out.
A great challenge!