Hi,
I have create a table as under
Dept Project Amount
IT Hardware 10000.00
IT SOFTWARE 3000.00
CIVIL Furniture 100000.00
CIVIL BUILDING AT NEW LOCATION 5000000.00
.
.
.
.
.
I want this table with sub-totals on dept.
i.e.
Dept Project Amount
IT Hardware 10000.00
IT SOFTWARE 3000.00
Total 13000.00
CIVIL Furniture 100000.00
CIVIL BUILDING AT NEW LOCATION 5000000.00
Total 5100000.00
Grand Total 5113000.00
