Very Thanks,
and i have a requirement like
date comp sectorid amount
1/12/2012 xxxx 0162 50
1/12/2012 xxxx 0162 50
1/12/2012 xxxx 0162 50
2/12/2012 yyyy 1234 90
2/12/2012 yyyy 1234 90
3/12/2012 zzzz 2356 180
5/12/2012 aaaa 0111 200
5/12/2012 aaaa 0111 400
6/12/2012 bbbb 0222 800
6/12/2012 bbbb 0222 800
now Requirement data like group by date and sector
This is for daily average balance
pls see the attach file