Phil, thank you for the hint regarding CTE

The final query that works:

With cte as 
(SELECT cb.[sl entry no], tot_cost = sum(cb.cost) from cb group by cb.[sl entry...