Spreadsheet: 690406d1597083073-using-sum-and-count-function-in-a-pivot-table-summary-consolidated-sheet
Sheet: Sheet12

 | Sum of Value | Column Labels
 | Row Labels | CPC HRS | CPC OT | JO/17/142 HRS | JO/17/142 OT | JO/19/202 HRS | JO/19/202 OT | JO/19/252 HRS | [NAME] | JO/20/083 HRS | JO/20/083 OT | JO/20/096 HRS | JO/20/096 OT | [NAME] | [NAME] | JO/20/120-B HRS | JO/20/120-B OT | JO/20/144 HRS | JO/20/144 OT | JO/20/164 HRS | JO/20/164 OT | JO/20/178 HRS | JO/20/178 OT | JO/20/183 HRS | JO/20/183 OT | JO/20/185 HRS | JO/20/185 OT | JO/20/186 HRS | JO/20/186 OT | JO/20/188 HRS | JO/20/188 OT | JO/20/193 HRS | JO/20/193 OT | [NAME] | [NAME] | JO/20/197 HRS | JO/20/197 OT | [NAME] | [NAME] | JO/20/202 HRS | JO/20/202 OT | [NAME] | JO/20/204 OT | JO/20/206 HRS | JO/20/206 OT | JO/20/209 HRS | JO/20/209 OT | JO/20/214 HRS | JO/20/214 OT | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | JO/20/218 HRS | JO/20/218 [NAME] | JO/20/219 HRS | JO/20/219 OT | Maintainance / Other works  HRS | Maintainance / Other works  OT | YARD1 CLEANING HRS | YARD1 CLEANING OT | YARD2 CLEANING  HRS | [NAME]
 | ABBASI |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | ANSARI |  |  |  |  |  |  |  |  | 12 |  |  |  | 8 |  | 18 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | DIPAK |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | 10
 | FELIX |  |  |  |  |  |  |  |  |  |  |  |  | 53 | 9
 | FLORENCIO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | GEORGE |  |  | 2 |  |  |  | 8 |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 5 |  | 2 |  |  |  |  |  |  |  |  |  | 3 |  | 13 |  |  |  |  |  |  |  |  |  | 5 |  | 2 |  |  |  | 1
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | HEMA |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | 5 | 4 |  |  |  |  |  |  | 8 |  | 6 |  | 8 |  | 14 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 4
 | KESHVAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | MALIK |  |  | 3 |  |  |  |  |  |  |  | 3 | 6 |  |  |  |  |  |  |  |  |  |  | 1 |  | 4 | 1 | 10 |  | 2 |  |  |  |  |  | 2 |  | 2 |  |  |  | 17 |  |  |  |  |  |  |  | 2 |  | 6 |  | 2 |  |  |  | 2
 | [NAME] |  |  |  |  |  |  | 1 |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 36 |  |  |  |  |  |  |  | 2 |  | 3
 | MANSA |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 | MARTIN
 | MATHEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 16
 | MUKUNDA |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | RAGESH |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 9 | 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 1 |  |  |  |  | 14
 | RAJA
 | RAJEEV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | RAVI |  |  |  |  |  |  | 1 |  |  |  | 3 | 5 |  |  |  |  | 4 |  |  |  | 1 |  |  |  | 24 | 1 | 3 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | SAMUEL |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | 1 |  |  |  | 3 |  | 7 |  | 25 |  |  |  | 2 |  |  |  |  |  | 4 |  | 2 |  | 2 |  | 5 |  | 1
 | SATHYA
 | SIMHA
 | SIVA |  |  | 3 |  |  |  | 13 |  |  |  | 7 | 2 |  |  |  |  |  | 2 |  |  | 1 |  | 4 |  | 1 |  | 5 |  |  |  |  |  |  |  | 2 |  | 7 |  | 3 |  | 2 |  |  |  |  |  |  |  | 2 |  | 3 |  | 2 |  |  |  | 1
 | SIVADAS | 52 | 8 |  |  | 4
 | SON |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 51 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | SUDHI |  |  |  |  |  |  |  |  |  |  | 13 | 4 | 4 |  |  |  | 28 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | UPENDRA
 | VINOTH |  |  |  |  |  |  |  |  |  |  |  | 8 | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Grand Total | 52 | 8 | 9 |  | 4 |  | 25 |  | 20 |  | 34 | 34 | 114 | 18 | 79 | 2.3 | 165 | 16 | 10 |  | 3 |  | 5 |  | 41 | 2 | 40 |  | 26 |  | 105 |  | 28 |  | 45 |  | 9 |  | 8 |  | 68 |  | 8 |  | 4 |  | 2 |  | 10 |  | 27 |  | 87 | 1 | 8 |  | 6 |  | 110