Summery field based on summaries from other columns (Weighted Average)

I solve it using another table to summarize field per Week Nr.
It is a pity that there are such limitations.
What about creating functionality which allow to do such weighted average or other top-line summaries.

Moreover, it would be nice to implement column color-coding base on score (numeric).