Daily Avg Balance

[#1]

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