Quick background: I have a list of people and their daily hours worked. I made a pivot table showing employees and how many hours they worked per day (Rows:Employee name, Columns:Individual Dates, Measure: Hours worked). I am struggling, however, to make another pivot table in which it sums all 12 hour violations per employee on a weekly basis.
Basically I want a pivot table with my rows to be Employee name, Columns to be Week of year (ie. 1,2,3, etc) and then the measure to be sum of 12 hour violations. Whenever I try and use the hours worked combined with an if function, it returns that they are all 12 hour violations because the employee worked more than 12 hours on the week as a whole.