Inventory of each dish

[Feras95p]

Dear all,

I have attached two excel files, The quantity and Products files.

In the quantity file I have two columns SKU and quantity. Whereas in the Products file I have the explanation of SKU. So that each SKU present the quantity of each dish sold.

What I'm looking for is that I want to have the total number sold of each dish in the product file.

So any help in that please? 

[Feras95p]

Exactly !

[Feras95p]

Yes yes exactly, could you please provide the workflow

[Kenda]

Got it! Sorry that took a minute to get me on the same page... In the last workflow I uploaded, simply change the Summarize tool so that it is not grouping by SKU. You can do this by highlighting that field in the Actions section then clicking the minus sign on the right. The tool should only be summing each of the Dish fields like this:

[Feras95p]

Thanks, it works great but there is one issue, it's not multiplying by the quantity, it always consider the quantity 1 whereas it could be more than one. How we can fix this issue?

[Feras95p]

Thanks it works well now