How can I calculate per hour, per day volumes if one or multiple days' data is selected?

[louwen]

hi. I have a scenario where i need to calculate the hourly and daily volume work effort of staff using specific criteria such as the days are 7 hours and days are 21 days in the month.

Easy enough i know, except i am using SLICERS to select the relevant month as well as the specific day in that month. This means that if I select one day only, the day data should only show that day and obviously the hourly average. But if I select multiple days in my SLICER I need some sort of formula to step in and then re-calculate the averages accordingly knowing that more than one day has been selected?
Below is an example of what I am looking at;

The Volume is for two days as selected via SLICER.



[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[/TR]
[TR]
[TD]Actual Volume
[/TD]
[TD]Per Hour (7 hrs)
[/TD]
[TD]Per Day (21 days)
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[louwen]

ok, now i am lost? Sorry, novice here that is still chuffed with myself that i got SLICER and VLOOKUP right.

 

[Andrew Poulsom]

What don't you understand?

 

[louwen]

Oh Ok,wait I see it now.

So by creating the table wit dates ad linking it to the slicer, soon as I select the relevant dates it changes it as well. This is then when the GETPIVOTDATA formula comes in?

 

[Andrew Poulsom]

Yes that's right.

 

[louwen]

Thank you. Will give it a try!

 

[louwen]

Thank you Sir! You are a genius! it worked great!!