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

    abril.susana

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

       

      Thanks!