declare @t table (part varchar(50), value1 int, value2 int, stuff1 varchar(50), value3 int, stuff2 varchar(50), value4 int)
insert @t select 'part1', 1, 2, 'stuff1.1', 3, 'stuff1.1.1', 5 union all select 'part1', 1, 2, 'stuff1.1', 3, 'stuff1.1.2', 6
union all select 'part1', 1, 2, 'stuff1.2', 8, 'stuff1.2.1', 7 union all select 'part2', 4, 2, 'stuff2.1', 3, 'stuff2.1.1', 5
union all select 'part2', 4, 2, 'stuff2.2', 3, 'stuff2.2.1', 6 union all select 'part3', 8, 45, 'stuff3.1', 5, 'stuff3.1.1', 10

;with tmp as (
  select *,
  case when row_number() over(partition by part order by (select 0)) = 1 then value1 else 0 end [value1_tmp],
  case when row_number() over(partition by part order by (select 0)) = 1 then value2 else 0 end [value2_tmp],
  case when row_number() over(partition by stuff1 order by (select 0)) = 1 then value3 else 0 end [value3_tmp],
  case when row_number() over(partition by stuff2 order by (select 0)) = 1 then value4 else 0 end [value4_tmp]
from @t
)
select part, value1, value2, stuff1, value3, stuff2, value4,
sum(value1_tmp) over() [Value1_Total], sum(value2_tmp) over() [Value2_Total], sum(value3_tmp) over() [Value3_Total], sum(value4_tmp) over() [Value4_Total]
from tmp