Compare Stock vs Order Pivot?

elgobuda
NewLounger
Posts: 5
Joined: 11 Oct 2021, 15:25

Compare Stock vs Order Pivot?

Post by elgobuda »

I have two Excel files

One contains all the products and the qty available in stock.

Second file contains all the orders of products and qty ordered.

How can I use a pivot to compare how much of the ordered qty can be fulfilled by stock available.

https://1drv.ms/x/s!At8Y6izJ9YrPooQbXWy ... A?e=8S5D4l

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Compare Stock vs Order Pivot?

Post by Rudi »

Hi,

Not sure if this helps? :cheers:

Data Consolidate.xlsx
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.