Calculate Previous Week

Hi everyone,

I am trying to fixed calculate the result for the previous week.

What I am trying to do is to create a calculation that will always show the result for previous week. for example:

January 19, 2020 will show 0

January 26, 2020 will show 5977

Feb 2 will show 6223

and so on...

I've tried the following calculation:

{ FIXED DATE(Dateadd('week', 1, datetrunc('week',[Week Start]))) : sum (New Business)}

but had no luck.

Please see workbook attached.

Thanks in advanced!

Yaron