Mike, I couldn't think of a neat way to get this on one sheet, but a dashboard worked fine. See the attached. I had to fake the two week calculations because your data does not reach to this week - you would replace
and similarly for Last week replace
You could also look at sparklines and a parameter to change the date range:
Thinking about the weeks - my calculations would be calendar week. If you wanted last 7 days and days 8-14 then the calcs would be a touch different.
Thanks very much -- this was quite helpful.