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
Compare Stock vs Order Pivot?
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Compare Stock vs Order Pivot?
Hi,
Not sure if this helps?
Not sure if this helps?
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.
Rudi
If your absence does not affect them, your presence didn't matter.