With such a small table the easiest is to use a recipe to get the final table you want, then publish it to the dashboard.
Here is an example using only a visual prepare recipe, it involves transposing, computing the sum, then transposing back.
Another solution to only get the sums is to use a prepare recipe to Fold your data (the opposite of a pivot), then use a groupby "Week" to get the sums.
With such a small table the easiest is to use a recipe to get the final table you want, then publish it to the dashboard.
Here is an example using only a visual prepare recipe, it involves transposing, computing the sum, then transposing back.
Another solution to only get the sums is to use a prepare recipe to Fold your data (the opposite of a pivot), then use a groupby "Week" to get the sums.