2 Replies Latest reply on May 16, 2018 7:54 AM by abril.susana

    Filter sum of week based on a selection of a day of that week


      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).