Using rolling dates and setting them as variables

[#1]

Hello !

I'm trying to figure out the sales for each of my clients in the last 90, 180, 365 days. I'd like to store the sales in those time-frames as variables.

I was trying something like: sum($<{Orderdate >= today()-365, Orderdate <= today()} $(vSales)) but to no avail...

Thanks a lot in advance !!!

[makkemik]

Hello Tomas,

I need the expretion like this;

when I selected Year or (Year and month), I want to find last 365 days sales (from max selected value to 365 days before)

Could you please send an example or set analyze ?

kind regards

Murat