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:

• Order #
• Item #
• Pieces
• Day ordered.
  my rows would duplicate to the amount of assorted items in that order. example, order 1234 has 3 items, so in Order # column, order 1234 will show 3 times.
  The goal again is to create a series of steps in power query to detect the best 10 items that will yield the completion of the most amount of orders available.
So far my report is based on the top 10 items sold but that does not guarantee the largest potential of order that can be filled.
Please, if someone has any guidance, I am a novice jumping into this role and doing well. This bit has been a challenge.

I’ve created my report in Power Query by pulling out APP orders and summing up the top 10 items. Any orders that match in a merge of queries to the exact items are HDS capable. In this case I’ve tried to use items on orders and turn them into a unique code to see what orders are “stackable” identical. But if 40 orders are the maximum amount of matching orders, it still won’t account for the other 6 best items to add into the HDS area for the maximum output. Even then this start of a process still does not guarantee the best item combination to yield the highest orders filled with a condensed 10 items.