Linked Dimensions Code help

[rohitians]

Dear Users,

I have a following scenario

wheres in one agreement number is linked to some other agreement number,

every agreement has a sanction and disburse  amount  but  where ever a linked agreement exist the sanction and disburse amount changes because the new amount is total of all link agreements as shown below.

Is it possible??

Request your help..

Agreement No	Sanction Amount	Disburse Amount	Linked Agreement No	New Sanction Amount	New Disburse Amount
100	100000	100000	102	300000	300000
102	100000	100000	103
103	100000	100000
104	100000	100000	105	200000	200000
105	100000	100000

Thanks and Regards,

Rohit Yadav

[jonathandienst]

Can you give some indication of what you expected? It looks OK to me but I don't know what values to expect.

It would also be helpful if you could upload the source QVD.