Sum up effort (allocated hours) only for current week

Hello everyone,

I am currently looking for a solution to sum up the effort (the allocated hours) in a report only for the current week. When creating a report with all active tasks due in the current week, the report currently sums up the allocated hours for the whole duration of the task or project and not only for the current week.

Does anybody have an idea how to get a sum of the allocated hours only for the week?

Thank you for your help!