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.
<tbody>
</tbody>
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.
A | B | C |
Actual Volume | Per Hour (7 hrs) | Per Day (21 days) |
15 |
<tbody>
</tbody>