Spreadsheet: 858945d1707418022-remove-subtotals-from-pivot-table-columns-only-pivottablesubtotals
Sheet: Sheet1

TaskName | TransactionDate | JobClass/Reference | EffortPC
BGCPT R&D | 2023-08-28 00:00:00 | Junior I | 153
BGCPT R&D | 2023-08-28 00:00:00 | Intermediate II | 490.5
BGCPT R&D | 2023-08-29 00:00:00 | Junior I | 497.25
BGCPT R&D | 2023-08-29 00:00:00 | Intermediate II | 163.5
BGCPT R&D | 2023-08-30 00:00:00 | Junior I | 306
BGCPT R&D | 2023-08-30 00:00:00 | Intermediate II | 327
BGCPT R&D | 2023-08-31 00:00:00 | Junior I | 344.25
BGCPT R&D | 2023-09-01 00:00:00 | Junior I | 765
BGCPT R&D | 2023-09-01 00:00:00 | Intermediate II | 436
BGCPT R&D | 2023-09-07 00:00:00 | Intermediate II | 109
BGCPT R&D | 2023-09-08 00:00:00 | Junior I | 726.75
BGCPT R&D | 2023-09-08 00:00:00 | Intermediate II | 163.5
BGCPT R&D | 2023-09-11 00:00:00 | Junior I | 726.75
BGCPT R&D | 2023-09-11 00:00:00 | Intermediate II | 163.5
BGCPT R&D | 2023-09-12 00:00:00 | Junior I | 918
BGCPT R&D | 2023-09-12 00:00:00 | Intermediate II | 218
BGCPT R&D | 2023-09-13 00:00:00 | Junior I | 459
BGCPT R&D | 2023-09-13 00:00:00 | Intermediate II | 163.5
BGCPT R&D | 2023-09-14 00:00:00 | Junior I | 191.25
BGCPT R&D | 2023-09-14 00:00:00 | Intermediate II | 218
BGCPT R&D | 2023-09-15 00:00:00 | Intermediate II | 654
BGCPT R&D | 2023-09-18 00:00:00 | Junior I | 420.75
BGCPT R&D | 2023-09-18 00:00:00 | Intermediate II | 1035.5
BGCPT R&D | 2023-09-19 00:00:00 | Junior I | 918
BGCPT R&D | 2023-09-19 00:00:00 | Intermediate II | 436
BGCPT R&D | 2023-09-20 00:00:00 | Junior I | 38.25
BGCPT R&D | 2023-09-20 00:00:00 | Intermediate II | 109
BGCPT R&D | 2023-09-21 00:00:00 | Junior I | 803.25
BGCPT R&D | 2023-09-21 00:00:00 | Intermediate II | 654
BGCPT R&D | 2023-09-22 00:00:00 | Junior I | 420.75
BGCPT R&D | 2023-09-22 00:00:00 | Intermediate II | 272.5
BGCPT R&D | 2023-09-25 00:00:00 | Junior I | 1109.25
BGCPT R&D | 2023-09-25 00:00:00 | Intermediate II | 109
BGCPT R&D | 2023-09-26 00:00:00 | Junior I | 267.75
BGCPT R&D | 2023-09-26 00:00:00 | Intermediate II | 1144.5
BGCPT R&D | 2023-10-17 00:00:00 | Junior I | 267.75
BGCPT R&D | 2023-10-18 00:00:00 | Junior I | 38.25
BGCPT R&D | 2023-12-01 00:00:00 | Junior I | 76.5
BGCPT R&D | 2023-12-05 00:00:00 | Junior I | 612
BGCPT R&D | 2023-12-06 00:00:00 | Junior I | 153
BGCPT R&D | 2023-12-07 00:00:00 | Junior I | 267.75
BGCPT R&D | 2023-12-11 00:00:00 | Junior I | 153
BGCPT R&D | 2023-12-18 00:00:00 | Junior I | 76.5
BGCPT R&D | 2023-12-18 00:00:00 | Junior II | 354
BGCPT R&D | 2023-12-22 00:00:00 | Junior II | 354
BGCPT R&D | 2023-12-28 00:00:00 | Junior I | 535.5
BGCPT R&D | 2024-01-02 00:00:00 | Junior I | 497.25
BGCPT R&D | 2024-01-02 00:00:00 | Junior II | 179
BGCPT R&D | 2024-01-02 00:00:00 | Intermediate II | 334.5
BGCPT R&D | 2024-01-03 00:00:00 | Junior I | 688.5
BGCPT R&D | 2024-01-03 00:00:00 | Junior II | 179
BGCPT R&D | 2024-01-03 00:00:00 | Intermediate II | 557.5
BGCPT R&D | 2024-01-04 00:00:00 | Junior I | 420.75
BGCPT R&D | 2024-01-04 00:00:00 | Intermediate II | 613.25
BGCPT R&D | 2024-01-05 00:00:00 | Junior I | 459
BGCPT R&D | 2024-01-05 00:00:00 | Intermediate II | 55.75
BGCPT R&D | 2024-01-09 00:00:00 | Intermediate II | 167.25
BGCPT R&D | 2024-01-16 00:00:00 | Junior I | 116.25
BGCPT R&D | 2024-01-16 00:00:00 | Intermediate II | 223
BGCPT R&D | 2024-01-17 00:00:00 | Junior I | 77.5
BGCPT R&D | 2024-01-17 00:00:00 | Intermediate II | 111.5
BGCPT R&D | 2024-01-18 00:00:00 | Intermediate II | 501.75
BGCPT R&D | 2024-01-19 00:00:00 | Intermediate II | 55.75
BGCPT R&D | 2023-08-28 00:00:00 | Intermediate I | 303
BGCPT R&D | 2023-08-29 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-08-30 00:00:00 | Intermediate I | 1717
BGCPT R&D | 2023-08-31 00:00:00 | Intermediate I | 808
BGCPT R&D | 2023-09-12 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-09-13 00:00:00 | Intermediate I | 606
BGCPT R&D | 2023-09-14 00:00:00 | Intermediate I | 808
BGCPT R&D | 2023-09-15 00:00:00 | Intermediate I | 1010
BGCPT R&D | 2023-09-18 00:00:00 | Intermediate I | 808
BGCPT R&D | 2023-09-19 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-09-20 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-09-21 00:00:00 | Intermediate I | 808
BGCPT R&D | 2023-09-22 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-09-25 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-09-28 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-09-29 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-10-11 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-10-12 00:00:00 | Intermediate I | 303
BGCPT R&D | 2023-10-13 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-10-17 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-10-18 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-10-19 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-10-23 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-10-25 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-10-26 00:00:00 | Intermediate I | 151.5
BGCPT R&D | 2023-10-30 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-10-31 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-11-01 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-11-02 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-11-03 00:00:00 | Intermediate I | 151.5
BGCPT R&D | 2023-11-07 00:00:00 | Intermediate I | 606
BGCPT R&D | 2023-11-08 00:00:00 | Intermediate I | 303
BGCPT R&D | 2023-11-10 00:00:00 | Intermediate I | 808
BGCPT R&D | 2023-11-15 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-11-17 00:00:00 | Intermediate I | 303
BGCPT R&D | 2023-11-20 00:00:00 | Intermediate I | 606
BGCPT R&D | 2023-11-24 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-11-27 00:00:00 | Intermediate I | 808
BGCPT R&D | 2023-11-28 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-12-01 00:00:00 | Intermediate I | 101
BGCPT R&D | 2023-12-05 00:00:00 | Intermediate I | 202
BGCPT R&D | 2023-12-06 00:00:00 | Intermediate I | 404
BGCPT R&D | 2023-12-07 00:00:00 | Intermediate I | 1010
BGCPT R&D | 2023-12-22 00:00:00 | Intermediate I | 101
BGCPT R&D | 2024-01-03 00:00:00 | Intermediate I | 206
BGCPT R&D | 2024-01-04 00:00:00 | Intermediate I | 103
BGCPT R&D | 2024-01-05 00:00:00 | Intermediate I | 206
BGCPT R&D | 2024-01-09 00:00:00 | Intermediate I | 103
BGCPT R&D | 2024-01-17 00:00:00 | Intermediate I | 103
BGCPT R&D | 2024-01-30 00:00:00 | Intermediate I | 206
BGCPT R&D | 2024-02-02 00:00:00 | Intermediate I | 103
BGCPT Maintenance | 2023-11-30 00:00:00 | Intermediate II | 54.5
BGCPT Maintenance | 2023-12-01 00:00:00 | Intermediate II | 163.5
BGCPT Maintenance | 2023-12-07 00:00:00 | Intermediate II | 54.5
BGCPT Maintenance | 2023-12-12 00:00:00 | Intermediate II | 54.5
BGCPT Maintenance | 2023-12-13 00:00:00 | Intermediate II | 163.5
BGCPT Maintenance | 2023-12-18 00:00:00 | Intermediate II | 327
BGCPT Maintenance | 2023-12-19 00:00:00 | Intermediate II | 436
BGCPT Maintenance | 2023-12-20 00:00:00 | Intermediate II | 981
BGCPT Maintenance | 2023-12-21 00:00:00 | Intermediate II | 381.5
BGCPT Maintenance | 2023-12-22 00:00:00 | Intermediate II | 54.5
BGCPT Maintenance | 2024-01-09 00:00:00 | Intermediate I | 154.5
BGCPT Maintenance | 2024-01-17 00:00:00 | Intermediate I | 154.5
BGCPT Maintenance | 2023-11-30 00:00:00 | Intermediate I | 202
BGCPT Maintenance | 2023-12-01 00:00:00 | Intermediate I | 404