I could transform your date string to date format using dateparse("YYYYMMDD",20160110).
Once we have the date format we can this in the calculated field to get the required sales result with filtering the same column for weeks.
I have attached the workbook. Hope this meets your requirement.
Date Transformation (9.0).twbx 16.3 KB