sql server - SSRS Sum visible parent row group -

hi have 2 row groups. , set second group hide unless click plus sign of parent group.

here raw dataset

projk   id1523  employee 100     3       joe001 100     3       kam002 100     3       mat102 201     5       joe001 201     5       mat122 203     1       kim222 

and here ssrs matrix. projk parent group. , notice id1523 not summarized sum(fields!id1523.value)

because don't use sum(fields!id1523.value) in id1523 column, when ssrs run report looks in ie

projk   id1523 +100     3 +201     5 +203     1 

even when rows expanded id1523 not repeat value in child group because of way set on matrix.

how can sum id1523 ? expect sum 3 + 5 + 1 = 9

right if add total projk group give me 3+3+3+5+5+1 = 20

i hoping can solve via sql raw dataset this

projk   id1523  employee 100     3       joe001 100     0       kam002 100     0       mat102 201     5       joe001 201     0       mat122 203     1       kim222 

raw data set result 2 table. simple left join on projk table1 looks this

  projk   employee     100     joe001     100     kam002     100     mat102     201     joe001     201     mat122     203     kim222 

and table2 looks this

projk   id1523   100     3        201     5        203     1        

i using partition , row_number determine each group in sql

then join first row_number of "table 1"