parent group should show total amt of all the child

Sep 3 2014 5:19 AM

parent group should show total amt of all the child
stored procedure we are using
for ex
Property, Plant & equipment - Parent tree = 600
1.Motor = 500
2 furniture = 100

I Need total amount of child 500 + 100 = 600
Advance thanks for valuable help