0 Replies Latest reply: Dec 5, 2014 2:01 AM by vamshi rup RSS

    Retail Sales Comparison- Like to Like Week Day

      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