: !/bin/sh

rm -f "div_tot.csv"
rm -f "egrid_tot.csv"
rm -f "extn_tot.csv"

awk -F',' '
{
	call_div = $1
	call_egrid= $2
	call_extn= $3
	call_date= $4
	call_cost= $13
	tot_div_arr[call_div] += call_cost
	tot_egrid_arr[call_div "," call_egrid] += call_cost
	tot_extn_arr[call_div "," call_egrid "," call_extn] += call_cost
}
END {
	for (div in tot_div_arr) {
		print div "," tot_div_arr[div] >>"div_tot.csv"
	}
	for (egrid in tot_egrid_arr) {
		print egrid "," tot_egrid_arr[egrid] >>"egrid_tot.csv"
	}
	for (extn in tot_extn_arr) {
		print extn "," tot_extn_arr[extn] >>"extn_tot.csv"
	}
}
' <c9.in