Actual data like the below one ----------------------------------------------------------- Family Error_type PartNum proc_num Error_msg ----------------------------------------------------------- 9AX752 ERROR3 3PN01HPX 1 invalid number 9AX752 ERROR3 3PN02Vb7 1 invalid HdaNum 9AX752 ERROR3 3WN01HgX 1 invalid Bupmap 9BD148 ERROR7 3QD0014V 1 HDA notfound 9BD148 ERROR7 3QV0044D 1 Resacn again 9XV952 ERROR9 3QD0014V 1 invalid bupnum 9XV952 ERROR9 3QV0044D 1 inalid serialnum 9xv952 ERROR9 3NPV004S 1 invalid bupmap i want to display like the below format with sub total and grand total based upon the grouping on family and error_type columns and rollup ----------------------------------------------------------- Family Error_type PartNum proc_num Error_msg ----------------------------------------------------------- 9AX752 ERROR3 3PN01HPX 1 invalid number 9AX752 ERROR3 3PN02Vb7 1 invalid HdaNum 9AX752 ERROR3 3WN01HgX 1 invalid Bupmap ---------- Sub total 3 9BD148 ERROR7 3QD0014V 1 HDA notfound 9BD148 ERROR7 3QV0044D 1 Resacn again ---------- Sub total 2 9XV952 ERROR9 3QD0014V 1 invalid bupnum 9XV952 ERROR9 3QV0044D 1 inalid serialnum 9xv952 ERROR9 3NPV004S 1 invalid bupmap ---------- Sub total 3 grand total 8