Hi

I have a data file like a.dat

item_no Item_id qty_ordered qty_delivered
123 axxx 1 1
456 axxx 2 2
899 axxx 2 2
789 bxxx 1 1
101 bxxx 2 2
111 bxxx 2 2


I want to split these single file in 2 file for the 2 different item_id like and get the totals of qty_order and qty_delivered.

item_no Item_id qty_ordered qty_delivered
123 axxx 1 1
456 axxx 2 2
899 axxx 2 2
--------------------------------------
total5 5 5

I tried to fetch those information in Spool file from data base and
put a grep -i "axxx" > c.dat
grep -i "bxxx" > d.dat

But i write a awk scrip to sum up and tried get the expected result...but am not able to..
Please suggest me some idea's to solve this.
Thanks in Advance!!