Spreadsheet: 715128d1611580442-sum-on-a-pivot-table-column-with-multiple-criteria-match-person-between-two-dates-resource-planning-dashboard_help
Sheet: Dashboard

Implementation Resource Planning
Team Member | Start Date | End Date | Allocation % |  |  | Employee |  | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.35 |  |  | [NAME]
 |  | 2021-05-31 00:00:00 | 0.04 |  |  | [NAME]
 |  | 2021-06-01 00:00:00 | 0.5 |  |  | [NAME]
 |  | 2021-06-12 00:00:00 | 0.04 |  |  | [NAME]
 |  | 2021-07-01 00:00:00 | 0.04 |  |  | [NAME]
 |  | 2022-05-22 00:00:00 | 1 |  |  | [NAME]
[NAME] | 2021-01-25 00:00:00 | 2022-05-22 00:00:00 | 1 |  |  | [NAME]
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.04 |  |  | Troy
 |  | 2021-05-31 00:00:00 | 0.04 |  |  | Unassigned
 |  | 2021-06-01 00:00:00 | 0.5 |  |  | Ellen
 |  | 2021-06-12 00:00:00 | 0.04
 |  | 2021-07-01 00:00:00 | 0.04
 |  | 2022-05-22 00:00:00 | 0.3
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.74
[NAME] | 2021-01-25 00:00:00 | 2021-05-31 00:00:00 | 0.35
 |  | 2021-07-01 00:00:00 | 0.35
 |  | 2021-12-31 00:00:00 | 0.35
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.04
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.04
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 1
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 0.08
 |  | 2022-05-22 00:00:00 | 1
Troy | 2021-01-25 00:00:00 | 2021-03-05 00:00:00 | 0.35
 |  | 2021-06-01 00:00:00 | 0.1
 |  | 2022-05-22 00:00:00 | 1
 |  | 2021-10-01 00:00:00 | 0.35
Unassigned | 2021-01-25 00:00:00 | 2021-06-30 00:00:00 | 0.04
 |  | 2021-07-31 00:00:00 | 0.04
 |  | 2021-12-31 00:00:00 | 0.04
Ellen | 2021-01-25 00:00:00 | 2021-02-05 00:00:00 | 0.35
 |  | 2021-05-31 00:00:00 | 0.27
 |  | 2021-06-12 00:00:00 | 0.35
 |  | 2021-06-30 00:00:00 | 0.27
 |  | 2021-07-01 00:00:00 | 0.1
 |  | 2021-07-31 00:00:00 | 0.27
 |  | 2021-12-31 00:00:00 | 0.27
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.1
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.1
[NAME] | 2021-01-25 00:00:00 | 2021-06-30 00:00:00 | 0.04
 |  | 2021-07-31 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.08
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.04
 |  | 2021-06-01 00:00:00 | 0.08
 |  | 2021-06-12 00:00:00 | 0.35
 |  | 2021-12-31 00:00:00 | 0.04
 |  | 2022-05-22 00:00:00 | 0.04
 |  | 2021-10-01 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.35
[NAME] | 2021-01-25 00:00:00 | 2021-06-30 00:00:00 | 0.35
 |  | 2021-07-31 00:00:00 | 0.04
 |  | 2021-10-01 00:00:00 | 0.1
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.35
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 1
 |  | 2022-05-22 00:00:00 | 0.5
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 1
 |  | 2022-05-22 00:00:00 | 0.1
[NAME] | 2021-01-25 00:00:00 | 2021-02-05 00:00:00 | 0.04
 |  | 2021-02-28 00:00:00 | 0.35
 |  | 2021-06-30 00:00:00 | 0.35
 |  | 2021-07-31 00:00:00 | 0.35
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.35
 |  | 2021-05-31 00:00:00 | 0.35
 |  | 2021-06-12 00:00:00 | 0.35
 |  | 2021-07-01 00:00:00 | 0.35
 |  | 2021-12-31 00:00:00 | 0.35
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.04
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.04