Please I need help.
On the list view of a timesheet, the entries are grouped by the week of year. Each week shows a heading with the respective days underneath. The duration field (joined from another table) shows the number of hours for each entry.
When I set the "SUM' calculation on the duration field, it only shows the accumulated total across all weeks, not by group by.
When I add split on week (same as group by) on the SUM, it gives the total for all weeks plus the total, underneath each group. How can I get it to show the week's (group's) total only.
Also is it possible to show this total in the group heading (this is the highlighted row with the group name, in this case the week number).
E.g. under each week it displays week 31, week 32, etc. and the total
Sum
31 & 31: 9.7
32 & 32: 9.4
Total: 19.1
On the list view of a timesheet, the entries are grouped by the week of year. Each week shows a heading with the respective days underneath. The duration field (joined from another table) shows the number of hours for each entry.
When I set the "SUM' calculation on the duration field, it only shows the accumulated total across all weeks, not by group by.
When I add split on week (same as group by) on the SUM, it gives the total for all weeks plus the total, underneath each group. How can I get it to show the week's (group's) total only.
Also is it possible to show this total in the group heading (this is the highlighted row with the group name, in this case the week number).
E.g. under each week it displays week 31, week 32, etc. and the total
Sum
31 & 31: 9.7
32 & 32: 9.4
Total: 19.1
Last edited: