Roll Up Hierarchy Wise Sales in Qlikview

[vikasmahajan]

Dear all,

Product	HQ	HQ2	No of Reps	Rmcount	MAT VAL Aug-14	We Want to calculate Sale Like this
METHYCAL TABLETS 15'S	Total				32		32
METHYCAL TABLETS 15'S	HYDERABAD POOL	HYDERABAD - 1 ABM	12	4	32	11
METHYCAL TABLETS 15'S	HYDERABAD POOL	HYDERABAD - 2 ABM	12	3	32	8
METHYCAL TABLETS 15'S	HYDERABAD POOL	HYDERABAD - 3 ABM	12	5	32	13.33333333

Please refer this table presently we are calculating sales on HQ Level (Gross Sales – Sales Return) at the lowest level , We have created hierarchy

in qlikview for rolling up this sales to upper level ie. HQ2 (RM-Level). When we insert dimension HQ2 in report  in report -> 32 sales is repeating

3 times but actually this sales should divide as per rmcount in given table  (11+8+13) = 32 will be sale for RM . I am stuck in logic how to implement

the same in Qlikview so need your assistance how to incorporate this logic in Qlikview.

Thanks

Vikas