Same Period Last Week

Hello... I'll simplify this by having only five columns within the SalesTransaction table:   TransDate (eg. 05/29/2018) TransTimePeriod (eg. 06:30-07:00) SaleAmount (eg. 200.00) ThisWeek ( measu...