We want a monthly report of timecard based on each user which will have columns as Group, User, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Total Hours.
For example on last month user A worked on Monday for 2, 4, 3, 5 hours/week so on report it should show sum of(2, 4, 3, 5) i.e. 14 under Monday column in last month report.
| Group | User | Mon | Tue | Wed | Thr | Fri | Sat | Sun | Total Hours |
| IT group | A | 14 | 20 | 40 | 32 | 40 | 0 | 0 | 146 |
Regards,
Dhanu
