Penny Bangalore
Board Regular
- Joined
- Apr 17, 2015
- Messages
- 79
Hi All,
Here i am looking for some idea, i can explain my requirement as my best, please reply for more clarification.
I work in an automobile industry where we quote the price of each and every products to our customer.
we have file around 40k rows for each week from last six months , where if i filter the items which i have was unable to supply the items, it will come to 15 k maybe.
my requirement is simple what is the best way to find out the products which i was not able to supply to my customer , i mean if i consolidate all the data of last six month the lines will become huge. in that i want to know which are the items that are keep on repeating as not supplied from last six month . so that i can give a report to my sales team" that we do not carry these products and we have demand for this".
Thanks
Here i am looking for some idea, i can explain my requirement as my best, please reply for more clarification.
I work in an automobile industry where we quote the price of each and every products to our customer.
we have file around 40k rows for each week from last six months , where if i filter the items which i have was unable to supply the items, it will come to 15 k maybe.
my requirement is simple what is the best way to find out the products which i was not able to supply to my customer , i mean if i consolidate all the data of last six month the lines will become huge. in that i want to know which are the items that are keep on repeating as not supplied from last six month . so that i can give a report to my sales team" that we do not carry these products and we have demand for this".
Thanks