Power query Aggregate list.sum with a condition, using aggregate

Hi

I am using "Merge" to combine/join two tables where I like to sum values from table 2.

Table1 has orderID (plus more):

Table2 is details for the order:

Il ike to get this result after merging

If I use the build in fucntion to aggregate/expand columns, I can only sum over the entire "Value" field per orderid.

I like something like List.Sum([Value] where Valuetype="CostA" ..)

And place in colum "CostA" respectively column "CostB".

Plus at he same time get the "first non blank value" of SalesDOk in "SalesDOk" column.

I cannot get around it, any one know?
Is it just me, I think M is not that intuitive like SQL?

Christian