I use pivot tables to compile order quantity data from different
customers.The orders are for different products with paramaters like style ,
colour , size etc.
For all such products we have stock quantity ready with us and also under
production(fixed total quantity )
As different customer orders come in - HOW can I allocate stock / production
on some priority basis for these customers - And thus to know if we have
overbooked in some colours / sizes .
Can anyone please help
Thanks Rohin