Parent Child addition

da

Hi ,

I need a help in calculation of data at lowest hierarchy level giving values to parent level.

For example,

l0	l1	L2	Data	Expected	Function used
A	a1	b1	11	33	=SUMIF
A	a1	b1	22	33
A	a2	b2	111	443
A	a2	b2	222	443
A	a2	b2	110	443

 

Here, I want values added of all the l2 who has same parent. Can anyone suggest me way out?

 

Thanks,

Divya

LipChean_Soh

Hi @da 

 

Below is an example of how you can do it. Please create a System module, i.e. L2 Details to follow the DISCO methodology.

  

 

 

Thanks,

LipChean