I have a report that displays weekly data for the entire year, as follows:
Clerk Hours Week 1 Week 2 Week 3... Week 13
Week 14 Week 15... Week 26
Week 27... Week 39
Week 40... Week52 Total
Manager Hrs Week 1 Week 2 Week 3... Week 13
Week 14 Week 15... Week 26
Week 27... Week 39
Week 40... Week52 Total
What I'd like to see is:
Clerk Hours Week 1 Week 2 Week 3... Week 13
Manager Hrs Week 1 Week 2 Week 3... Week 13
Clerk Hours Week 14... Week 26
Manager Hrs Week 14... Week 26
Clerk Hours Week 27... Week 39
Manager Hrs Week 27... Week 39
..., etc.
Is this a grouping issue? Can this be accomplished? Thanks.
Clerk Hours Week 1 Week 2 Week 3... Week 13
Week 14 Week 15... Week 26
Week 27... Week 39
Week 40... Week52 Total
Manager Hrs Week 1 Week 2 Week 3... Week 13
Week 14 Week 15... Week 26
Week 27... Week 39
Week 40... Week52 Total
What I'd like to see is:
Clerk Hours Week 1 Week 2 Week 3... Week 13
Manager Hrs Week 1 Week 2 Week 3... Week 13
Clerk Hours Week 14... Week 26
Manager Hrs Week 14... Week 26
Clerk Hours Week 27... Week 39
Manager Hrs Week 27... Week 39
..., etc.
Is this a grouping issue? Can this be accomplished? Thanks.