Shell Programming and Scripting

Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5

Assignee Group1 Group2 Group3 Toatl_Assignee_Wise
ABC 17 0 0 17
PQR 0 5 6 11
XYZ 10 0 5 15
 
Grand Total: 43 (17+11+15)

FNR > 1 {
 if (!($2 in gA)) {
   gA[$2]
   gAl[++gC]=$2
 }
 aA[$1,$2]+=$3
 aAa[$1]
}
END {
  printf("Assignee")
  for(i=1;i<=gC;i++)
    printf("%s%s%s", OFS, gAl[i], (i==gC)?OFS "Total_Assignee_Wise" ORS:"")

  for(j in aAa) {
    printf("%s", j)
    t=0
    for(i=1;i<=gC;i++) {
      idx=j SUBSEP gAl[i]
      t+=aA[idx]
      printf("%s%d%s", OFS,(idx in aA)?aA[idx]:0, (i==gC)?OFS t ORS:"")
    }
    tt+=t
  }
  printf("\nGrand Total: %d\n", tt)
}