I spent the entire morning trying to figure this out but apparently it’s not possible.
We have a supplier who sends us multiple packing lists per order. each packing list is basically a box with tracking number.
Please check out this example base:
What we’re trying to achieve, is to rollup the Quantity per each product per order in 1 line.
So the only way to do this is to get all the rows that match order number & product number, then rollup their quantities.
Thank you in advance.
Sorry that you haven’t had a response. Just so I totally understand the problem, you are looking to sum the quantity of each product for each order? Something like this:
Let me know if I have the right idea.