Analytic question - sum table column for items completed last week

[RDuke]

I have a need to run an analytic that sums values in one column based on the dates of another column that fall within the “last week.”