I think there may be a few more steps needed to get the weekly sum.
I think you will need to have the Day on the Detail shelf.
Then, I think you can just use a WINDOW_SUM([Sales without QC]).
The next part will be the Table Calculation settings (as shown in the screenshot below).
Lastly, there are multiple copies of the value (because of putting the Day on the detail shelf)
but this can be filtered down to one value by putting Index on the filter shelf,
making it's table calc settings the same as above, and filtering to one.
Please see the workbook attached in the Forum Thread.
275384sum.twbx 1.2 MB
Thanks for your help
I have tired to this but a bit confised I am tryinh get this into a weekly view but with the correct numbers added. i have a attached TWBX file for your reference
Sales lod-lookups.twbx 70.7 MB