AsOfDate Table

[diogoduarte]

Hi, i have a simple table with dimension month and i need calculate the sum of sales for last 90 days, but with set analyses returns the result only the last month.

I use the expression Sum({$<Dia={"$(=Date(Max(Dia)))"} , Flag={"60 Dias"} >} Vendas), but the function Date(Max(Dia)) does not run per line, returns only the maximum date of the data.

[Channa]

=Sum({$<[Ship Date]={">=$(=MonthStart(Today(),-3))<$(=monthend(Today(),0))"}>}Sales)

try to use similar 

if you don't have date try to add date column in DB first date of every month