This content has been marked as final. Show 2 replies
I have the daily hours worked for each employee in my organization. I'm looking at the daily and weekly sum of hours. I'm looking for a way to filter the data so that if I select a day in my hours by day table, I can see the sum of hours per week in my hours by week table.
Currently this is what happens:
I want this to happen:
The second picture shows the sum of hours for the week of April 1, 2018.
I tried using a LOD calculation but I'm not sure how to fix the calculation based on weekly dates.
Attached is the packaged workbook (version 10.4).