Help

Match Multiple Columns and rollup value of third

Topic Labels: Base design
1907 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Berat
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

4 Replies 4
Berat
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m still hoping someone would be able to help with this.

Hi Berat,

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:

  • Order 1 - Product 1: 25
  • Order 1 - Product 2: 25
  • Order 2 - Product 3: 30
  • Order 2 - Product 4: 35

Let me know if I have the right idea.

Chris

Hi @Christopher_Williams

Thank you for your response.

That’s exactly what i’m trying to achieve in the “Products Per Order” table.

Hi @Berat,

Try this…

Create a field in your Products table to rollup the Qty from Orders
image

Then, change your field in Products per Order table to a lookup bringing the rollup qty into this table.
image

Let me know what you think.
Chris