1BEGIN { FS = "\t" } 2 { pop[$4 ":" $1] += $3 } 3END { for (cc in pop) 4 print cc ":" pop[cc] | "sort -t: -k 1,1 -k 3nr" } 5