Hi, and happy new year people.
1. I am looking for an overview of how many different delivery days each order stands for regarding service level.
a. From attached example:
i. 31 2 (1/1 & 1/3)
ii. 32 1 (1/2)
iii. 33 1 (1/2)
iv. 34 2 (1/3 & 1/5)
v. 35 1 (1/2)
2. How many of the total orders is code A, B or C.
3. and here comes what I believe is the tricky part; If an order has more than one delivery day, I would like to know which product on that order is delivered late, including the code on that product.
4. Ive also thought a lot on what extra info that would be nice to look at regarding this, i.e. how many of code A, B or C products are second or third delivery, and which products this is Is it possible?
I have somewhat resolved number 1 using Pivot, but I do think it could be solved in a better manner. Preferably, I think a template where I can paste in the statistics with some formulas on top would do the job hopefully someone might be able to help me out with this one!
Kind regards,
H
Bookmarks