User Criteria :
Week :always starts on Friday and end on Thursday.
Store Closed Sat and Sun
Compare Current Year Week1 - Prior Year Week1
If Current Year Week 1 has 3 days of sales and Prior Year Week 1 has 5 days of sales then It should return only 3 days of sales
Week 1 Current Year Prior Year
mon 100 100
Tue 100 100
Wed 0 100
Thur 0 100
Friday 100 100
It has to compare Mon , Tue and Friday.
Table:
TransactionDate
Store
Sales Amount
Thanks