Hi All I am new to slicer and have been asked to create a dynamic slicer which shows resource allocation %, whenever each resource is selected based on the month selected. struggling for last 6 hrs
below is the data in the excel file, can someone please help
below is the data in the excel file, can someone please help
ID | Resource | Project Name | Daily Rate | Start Date | Finish Date | Working Days | % Allocation | Equivalent Hours /week | Total Effort (Hours) |
1 | Nicole Kline-Marantelli | Stud Book and Equine Welfare and Traceability Rules | $ - | 1/12/2020 | 29/01/2021 | 42 | 65% | 24.7 | 207.48 |
1 | Nicole Kline-Marantelli | Stud Book and Equine Welfare and Traceability Rules | $ - | 8/02/2021 | 19/02/2021 | 10 | 40% | 15.2 | 30.4 |
1 | Nicole Kline-Marantelli | Stud Book and Equine Welfare and Traceability Rules | $ - | 22/02/2021 | 31/05/2021 | 68 | 20% | 7.6 | 103.36 |
2 | Ally Ghayour | Stud Book and Equine Welfare and Traceability Rules | $ - | 4/01/2021 | 31/05/2021 | 102 | 100% | 38 | 775.2 |
3 | Biju Kuruvila | Stud Book and Equine Welfare and Traceability Rules | $ - | 4/01/2021 | 31/05/2021 | 103 | 100% | 38 | 782.8 |
4 | Jimit Rajani | Stud Book and Equine Welfare and Traceability Rules | $ - | 18/01/2021 | 31/05/2021 | 94 | 100% | 38 | 714.4 |
5 | Vamina Gad | Stud Book and Equine Welfare and Traceability Rules | $ - | 4/01/2021 | 31/05/2021 | 105 | 100% | 38 | 798 |
6 | Vinay Varghese | Stud Book and Equine Welfare and Traceability Rules | $ - | 18/01/2021 | 31/05/2021 | 96 | 100% | 38 | 729.6 |
7 | Vitaly Belevtsev | Stud Book and Equine Welfare and Traceability Rules | $ - | 18/01/2021 | 31/05/2021 | 96 | 70% | 26.6 | 510.72 |
9 | Manali Modi | Stud Book and Equine Welfare and Traceability Rules | $ - | 15/03/2021 | 30/06/2021 | 78 | 100% | 38 | 592.8 |
10 | Jason Wang | NZTR | $ - | 12/01/2020 | 31/08/2021 | 427 | 75% | 28.5 | 2433.9 |
11 | Manali Modi | Ongoing Development and Expansion of Stable Assist | $ - | 1/09/2020 | 14/03/2021 | 139 | 100% | 38 | 1056.4 |
12 | John Suen | Owners Verification (Green ID) | $ - | 1/02/2021 | 12/02/2021 | 10 | 80% | 30.4 | 60.8 |
13 | John Suen | Decomissioning of Azure | $ - | 1/02/2021 | 5/02/2021 | 5 | 20% | 7.6 | 7.6 |
14 | Vinay Varghese | Decomissioning of Azure | $ - | 1/02/2021 | 5/02/2021 | 5 | 20% | 7.6 | 7.6 |
15 | Marco Cordeiro | Ongoing RA Mobile App Development | $ - | 29/06/2020 | 9/03/2021 | 182 | 100% | 38 | 1383.2 |
16 | Vijaya Kedarasetti | BAU / Small Projects / Change Requests | $ - | 29/06/2020 | 25/12/2021 | 390 | 100% | 38 | 2964 |
17 | Falguni Chavda | BAU / Small Projects / Change Requests | $ - | 29/06/2020 | 22/03/2021 | 191 | 100% | 38 | 1451.6 |
18 | Sivareddy Bandreddi | BAU / Small Projects / Change Requests | $ - | 29/06/2020 | 25/12/2021 | 390 | 100% | 38 | 2964 |
19 | Selgin Inan | BAU / Small Projects / Change Requests | $ - | 29/06/2020 | 14/03/2021 | 185 | 100% | 38 | 1406 |
19 | Selgin Inan | BAU / Small Projects / Change Requests | $ - | 15/03/2021 | 30/06/2021 | 78 | 20% | 7.6 | 118.56 |
19 | Selgin Inan | BAU / Small Projects / Change Requests | $ - | 1/07/2021 | 25/12/2021 | 127 | 20% | 7.6 | 193.04 |