Hi Guys,
I need some help finding a formula that will give me the total sales units of an item where I need to add the sales units of the "Parent" and the minimum sales units of the "Box" that relate to the item.
For example below, Item 1 is the sum of Item 1 (Parent) + minimum of (Item 1 Box 1) and (Item 1 Box 2), therefore 5 + 1 = 6.
I would like to display the totals by Master SKU in a separate table, as shown in Table 2.
Is there a forumula where I can use the "Master SKU" column and the "Parent/Box" column that will give me the correct answer?
Table 1 - Raw Data
<tbody>
</tbody>
Table 2 - Total Sales by Master SKU
<tbody>
</tbody>
Thanks in advance for your help!
I need some help finding a formula that will give me the total sales units of an item where I need to add the sales units of the "Parent" and the minimum sales units of the "Box" that relate to the item.
For example below, Item 1 is the sum of Item 1 (Parent) + minimum of (Item 1 Box 1) and (Item 1 Box 2), therefore 5 + 1 = 6.
I would like to display the totals by Master SKU in a separate table, as shown in Table 2.
Is there a forumula where I can use the "Master SKU" column and the "Parent/Box" column that will give me the correct answer?
Table 1 - Raw Data
SKU Description | Master SKU | Parent/Box | Sales Units |
Item 1 (Parent) | Item 1 | Parent | 5 |
Item 1 (Box 1) | Item 1 | Box | 1 |
Item 1 (Box 2) | Item 1 | Box | 2 |
Item 2 (Parent) | Item 2 | Parent | 20 |
Item 2 (Box 1) | Item 2 | Box | 5 |
Item 2 (Box 2) | Item 2 | Box | 5 |
Item 2 (Box 3) | Item 2 | Box | 6 |
<tbody>
</tbody>
Table 2 - Total Sales by Master SKU
Master SKU | Total Sales Units |
Item 1 | 6 |
Item 2 | 25 |
<tbody>
</tbody>
Thanks in advance for your help!