Hey @Ryan_Hubbard ,
Great question. In th eWeekly Report table, you will want to create a column for each task, that looks to the lower table and then filters it by the same name. Something like:
Time Entries.filter(task.containstext(thisrow.task)).time.sum()
You may have to paly with the containstext, to use that one, or just contains, but that should give you the sum of each task by week. You can do the methodology when creating the name if you want too.
Hopefully that helps!
Best,
Dan