Help Summarizing Timekeeping Data

[katherinetdavita]

Hello!

I'm trying to make some timekeeping data look as much like a pivot table as possible so that a non technical person can sort by TM ID and have a picture of the date that's easier for them to review- I've looked at a few other community posts on this suggesting the summarize and the cross tab tool, and I may use those, but I'm stuck. In my data below, the area in green is what my workflow is already outputting, but the yellow section is what I need my next step to do. I need a column that totals the hours by transaction date and I need a total by week ending date.

The part I'm having trouble with is that when there are regular hours (blank in PayCodeName) - the value is captured twice: once in TotHours and again in RegHours. I need a total by Transdate that only captures it once. Then I need a total by week ending.

 

[binuacs · Accepted solution]

@katherinetdavita