Trial Balance Query

[nadirpervez]

Dear All

I have 2 tables,
1) Chart_of_account
2) GL_OPEN_BALANCE
i have fetched the data from "Chart_of_account" hirarchy wise and associate all the balances from "GL_OPEN_BALANCE".
The Problem is that, all the balances are occuring at the lowest level i.e level 4
Now i want to get the cummulative balance of level 4 to level3 with respect to their parent. Then accumulated balance of level 3 to level 2 and accumulated balance of level 2 to level1.

Please help me in this regard
my email address is "nadirpervez@gmail.com"

regards