Filter for the previous 5 weeks

[DoraS]

Hi

I need to create a bookmark for the previous 4 weeks, but in my case the week is the first day of week.

Ex: Today is 01/04 and the Weekstart(today) is 28/03. I want a filter with 28/03, and 21/03 and 14/03 and 07/03.

Thanks

Dora

[hic]

One way to do this is to define a relative week in the script:

Div(WeekStart(Today()) - Weekstart(Date),7) as RelativeWeek,

Then it becomes a simple selection of 0 to 4, that you can save as a bookmark.