Create table matrix

hello, how to set up data structure in bubble when I want to achieve the following:

So the dates are flexible as they change per week.
data per categorie should be labeled with a date (or week).
And the numbers per category / week combination are a aggregation of multiple lines.
Category 6 is a sum of the categories 1-5

Any idea on how achieve this in Bubble? I have been trying to get this with repeating group, but I can’t get it done.

My db structure is as follows:

or should i have a column for each week? I need to look forward for half a year so 26 weeks…

I’m trying to do something similar. Did you manage to figure this out?