Guys I have a situation where i have got different SKU which are being shipped to different countries with unique order no.
Now i have to find out/extract/identify the last order shipped with the help of delivery date along with quantity of the particular SKU for the given country.
Database attached over here
example :
order highlighted in red is the last order delivered till date for United Kingdom
order highlighted in Blue is the last order delivered till date for Switzerland
order highlighted in Pink is the last order delivered till date for Ireland..
Likewise for other SKU as well
and if there is no delivery date that means that order has not been shipped yet
533054 | GB | United Kingdom | 1001479726 | 42 | 27-01-20 |
533054 | GB | United Kingdom | 1001479727 | 42 | 09-03-20 |
533054 | GB | United Kingdom | 1001479728 | 42 | 20-04-20 |
533054 | GB | United Kingdom | 1001479729 | 42 | 17-05-20 |
533054 | GB | United Kingdom | 1001479730 | 42 | 28-08-20 |
533054 | CH | Switzerland | 1001479732 | 10 | 03-10-19 |
533054 | CH | Switzerland | 1001479733 | 78 | 06-02-20 |
533054 | IE | Ireland | 1001479740 | 10 | 04-05-20 |
533054 | CH | Switzerland | 1001479743 | 48 | 11-08-20 |
533054 | GB | United Kingdom | 1001479745 | 42 | 17-06-20 |
533054 | GB | United Kingdom | 1001479748 | 84 | 27-07-20 |
533054 | CH | Switzerland | 1001479754 | 200 | 06-08-20 |
533054 | CH | Switzerland | 1001479759 | 5 | 14-04-20 |
533054 | CH | Switzerland | 1001479772 | 5 | 30-06-20 |
533054 | CH | Switzerland | 1001479775 | 5 | 25-08-20 |
Thanks in Advance
Solved! Go to Solution.
Hi @hishashvat I mocked up a workflow that I think does what you ask let me know what you think?
Yes it works. Thank you
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |