Previous 7 days data when a date is selected

[renjithpl]

Hi All,

I have to find sum of sales of previous 7 days when i select a date (including the selected date).

Any idea ?

Regards

Renjith

[CELAMBARASAN]

Hi,

     Try this

     Sum({<DateField={">=$(=Max(Floor(Num(DateField))-7)<=$(=Max(DateField))"}>} Sales)

[renjithpl]

Thanks for the reply, but its not working!!

[CELAMBARASAN]

Sum({<DateField={">=$(=Date(Max(Floor(Num(DateField))-7))<=$(=Date(Max(DateField)))"}>} Sales)

[SunilChauhan]

see the attched file

hope this helps

[renjithpl]

I want it in a text box, i dont know for what reason, it shows the sales only for the selected date, its not returning for 7 days sales.

[SunilChauhan · Accepted solution]

in expression  replace 7 with 6

and copy to text

see the attched file

hope this may helps