roll up of hierarcial data different levels

[#1]

Hi all,

i have 6 level hieraracial data.hierarchy is adject node hierarchy (i.e parent code ,code,name)

.data will be at level 4 or level 5 or level 6.some data can be at 4 and some data can be at 5 and some data can be at 6.

to get upper level i need to do average of lower level.i how i can aggregate data automatically in qlikview to get data at all levels and higher level

ex:

parent code	code	name	data
001-010301	001-01030101	ft	4.2
001-010301	001-01030102	mc	4.8
001-0103	001-010301	ms	4.5 (derived)
001-0103	001-010302	fa	3.5
001-01	001-0103	tran	4.0 (derived)

Thanks in advance....

[robert_mika]

Could you post your data and desired result?

[#3]

Hi robert,

in example i specifed.data with (derived) should be calculated in qlikview .derived will be blank in data.

thanks.