Getting a correct sum when having multiple rows and multiple tables

Hi InspectahJ

For the picture from your last reply, Are "COGS1", "COGS2", "COGS3" columns from table1 and is "summa logcosts" a column from table2?

I don't see  "summa logcosts" from table2, why?

The two tables have a relationship and I get the total cost (COGS+logistics cost) to work on a total level.

From all your replies, i still don't find any total cost (COGS+logistics cost), does total cost (COGS+logistics cost) mean to add column "COGS" from table1 and column "logistics cost" from table2?

For example

table1                                                         table2          

COGS  ordernumber                                  logistics cost            ordernumber

1          1                                                     1                               1

2          1                                                     2                               2

3          1

3          2

4          2

5          2

so total (COGS + logistics cost) per order number shoule be:

total                        ordernumber

(1+2+3)+1              1

(3+4+5)+2              2

Is my understanding right?

Best Regards

Maggie