Hello Everyone,
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.