the answer id like is the Total Overall, its separate from that sample you have posted. so like to the side id like it to say the date then below that the Total Overall. Then as the date will change each day as it does and passes to the next week, then id like the Total Overall to change to that weeks figure.
so say today is the 20-jun then the Total Overall would be £236, and as the date changes to the 23-june the Total Overall would automatically change to £226.

do you see what I mean ?