I am trying to create a report that shows overtime based on hours over 40 per week
I can create the formula that shows the overtime by employee for a week that is because I am only pulling in one week worth of records and grouping by employee.
I want to sum the overtime based on a Criteria of the employee example:
Criteria /Employee / Hours / OT hours - Group footer
Admin / Hours/ OT
Direct Labor / Hours/OT