I was hoping to receive some help. I am working on a process through Power Query to identify the 10 best combination of items that will complete the largest amount of orders. We have a variety well over 1k items. I am new to the position and need some guidance on taking my reporting to a higher level. Example would be out of 10k orders there are various amount of items and pieces attached.
Table columns are set: