Need to setup slicer for allocation percentage for each resource for the each month

param

New Member
Joined
Oct 22, 2012
Messages
29
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

IDResourceProject NameDaily RateStart DateFinish DateWorking Days% AllocationEquivalent Hours /weekTotal Effort (Hours)
1​
Nicole Kline-MarantelliStud Book and Equine Welfare and Traceability Rules$ -
1/12/2020​
29/01/2021​
42​
65%​
24.7​
207.48​
1​
Nicole Kline-MarantelliStud Book and Equine Welfare and Traceability Rules$ -
8/02/2021​
19/02/2021​
10​
40%​
15.2​
30.4​
1​
Nicole Kline-MarantelliStud Book and Equine Welfare and Traceability Rules$ -
22/02/2021​
31/05/2021​
68​
20%​
7.6​
103.36​
2​
Ally GhayourStud Book and Equine Welfare and Traceability Rules$ -
4/01/2021​
31/05/2021​
102​
100%​
38​
775.2​
3​
Biju KuruvilaStud Book and Equine Welfare and Traceability Rules$ -
4/01/2021​
31/05/2021​
103​
100%​
38​
782.8​
4​
Jimit RajaniStud Book and Equine Welfare and Traceability Rules$ -
18/01/2021​
31/05/2021​
94​
100%​
38​
714.4​
5​
Vamina GadStud Book and Equine Welfare and Traceability Rules$ -
4/01/2021​
31/05/2021​
105​
100%​
38​
798​
6​
Vinay VargheseStud Book and Equine Welfare and Traceability Rules$ -
18/01/2021​
31/05/2021​
96​
100%​
38​
729.6​
7​
Vitaly BelevtsevStud Book and Equine Welfare and Traceability Rules$ -
18/01/2021​
31/05/2021​
96​
70%​
26.6​
510.72​
9​
Manali ModiStud Book and Equine Welfare and Traceability Rules$ -
15/03/2021​
30/06/2021​
78​
100%​
38​
592.8​
10​
Jason WangNZTR$ -
12/01/2020​
31/08/2021​
427​
75%​
28.5​
2433.9​
11​
Manali ModiOngoing Development and Expansion of Stable Assist$ -
1/09/2020​
14/03/2021​
139​
100%​
38​
1056.4​
12​
John SuenOwners Verification (Green ID)$ -
1/02/2021​
12/02/2021​
10​
80%​
30.4​
60.8​
13​
John SuenDecomissioning of Azure$ -
1/02/2021​
5/02/2021​
5​
20%​
7.6​
7.6​
14​
Vinay VargheseDecomissioning of Azure$ -
1/02/2021​
5/02/2021​
5​
20%​
7.6​
7.6​
15​
Marco CordeiroOngoing RA Mobile App Development$ -
29/06/2020​
9/03/2021​
182​
100%​
38​
1383.2​
16​
Vijaya KedarasettiBAU / Small Projects / Change Requests$ -
29/06/2020​
25/12/2021​
390​
100%​
38​
2964​
17​
Falguni ChavdaBAU / Small Projects / Change Requests$ -
29/06/2020​
22/03/2021​
191​
100%​
38​
1451.6​
18​
Sivareddy BandreddiBAU / Small Projects / Change Requests$ -
29/06/2020​
25/12/2021​
390​
100%​
38​
2964​
19​
Selgin InanBAU / Small Projects / Change Requests$ -
29/06/2020​
14/03/2021​
185​
100%​
38​
1406​
19​
Selgin InanBAU / Small Projects / Change Requests$ -
15/03/2021​
30/06/2021​
78​
20%​
7.6​
118.56​
19​
Selgin InanBAU / Small Projects / Change Requests$ -
1/07/2021​
25/12/2021​
127​
20%​
7.6​
193.04​
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,132,706
Messages
5,654,845
Members
418,155
Latest member
demasisi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top