I'm afraid I'm a little confused on what the final goal is. Do you want to filter the view to show only locations that are over/under 10 hours? Do you want to dynamically color the locations based on whether they are over/under 10 hours?
Maybe you can make a mockup in Excel or Paint that shows how the final view should look?
In the attached workbook, I created a calculated field called "Met Benchmark" and used it to color the text. This approach uses a table calculation to SUM all of the hours across all employees for each Location & Date. If you aren't familiar with table calculations, you'll want to spend some time understanding how they work.
1. Create a calculated field called "Met Benchmark", which will return True if the total hours worked are less than or equal to 10:
WINDOW_SUM(SUM([Time Worked])) * 24.0 <= 10
2. Drag the calculated field to Color and set the "Compute Using" to Employee, as shown below. This means the table calculation will be calculated across all Employees for each Location and Date.
3. Set colors appropriately (I used black and red) and it should look something like this:
Hope this helps,
Example.twbx 31.0 KB