Hi,
I try to do cost analysis where I group suppliers that have many similar companies under one supplier name . I succeeded to do this with if statement:
=if(WildMatch([Supplier ID], '1111', '1112','1113' ),'Orange', if(WildMatch([Supplier ID], '2222'),'Apple', 'Other')
Now the problem is that this year Apple started to supply Orange's products. I would like to still follow the costs of those products under the name of Orange. To separate Orange's costs from Apple's costs, there is an additional code "1234" that is used.
So the data is now:
| Supplier ID | Supplier name | Code | Costs |
| 1111 | Orange East | | 10 |
| 1112 | Orange West | | 20 |
| 1113 | Orange South | | 30 |
| 2222 | Apple | 1234 | 50 |
| 2222 | Apple | | 20 |
Now I would like to see in a report that the total cost of Orange is (10+20+30+50)= 110 and total cost of Apple is 20 using that code. How am I able to achieve that?
