Sum values of parent and subsequent children

[iLoveTea]

Hello my dear community, 

1. Here's my problem in an image as it is worth a 1000 words :

As you can see above, the bold row ".trk.trk02.trk02-1.AMPHENOL.GEP.LOT2" is the sum of all GEP.LOT2 children in yellow.

The problem is it doesnt count the row NOT in bold ".trk.trk02.trk02-1.AMPHENOL.GEP.LOT2" in blue.

The measure _DureeJour is calculated as follows  = IF(sum(ACT_activite[sec_spend_time])=0,BLANK(),CONCATENATE(trunc(sum(ACT_activite[sec_spend_time])/(3600*8),3)," J"))

The measure _DureeHM is calculated as follows

= IF(sum(ACT_activite[sec_spend_time])=0,BLANK(), CONCATENATE(CONCATENATE([Duree_H],"h"),CONCATENATE([Duree_M],"m")))

2. Here's what i would like to have :

 

Thanks,

[v-jingzhang]

Hi @iLoveTea 

It is because ".trk.trk02.trk02-1.AMPHENOL.GEP.LOT2" is under parent ".trk.trk02.trk02-1.AMPHENOL.GEP" rather than ".trk.trk02.trk02-1.AMPHENOL.GEP.LOT2" itself in the matrix currently. 

Can you show how this parent column and its child column display in their data table? 

If ".trk.trk02.trk02-1.AMPHENOL.GEP.LOT2" row has got the expected result "62.428 J", should ".trk.trk02.trk02-1.AMPHENOL.GEP" row be updated with a new total value (= 41.562 + 62.428)? 

Best Regards,
Community Support Team _ Jing

[dfs29]

hi @v-jingzhang 

Here my table :

Thanks