Average of the last three mondays

[Anonymous]

Hi everyone, does anybody know if there's a way to set the sum analisys of the las 3 mondays( of any other weekday) given a date.

Lets say I have the following table

I need a result table like the one in the rigth side.

Thanks in advance

[maxgro]

Sum({<Calendate={"<=$(=Today())>=$(=date(Today()-20))"}>} if(WeekDay(Calendate)='mon', Amount))

[ramoncova06 · Accepted solution]

sum({

<CalendarDate = {">=$(=DATE(FLOOR(WEEKSTART(MAX(CalendarDate),-2))))"}>

*

<CalendarDate = {"=WeekDay(CalendarDate)=0"} >

}SalesAmount)

** changed to sum instead of avg

[Anonymous]

Thank you both of you. The two ways are correct!! At least to me.

[ramoncova06]

Glad it worked ... that one of the things with QV you can have several ways for getting the same results