Set Analysis between to dates

[#1]

Hi

Can somebody help me her?

sum({$ <Date={$(=<only(Date)-1>only(Date)-60)}>} Sales)

I am trying to get sum of sales between selected date-60 and selected date-1

[mike_garcia]

Hello,

You can try:

sum({$<Date = {">=$(=only(Date)-60)<=$(=only(Date)-1)"}>} Sales)

Regards,

Mike.

[spsrk_84]

can u give some example for the scenario what u said

so that it will be easy to give the solution

[#4]

Hi Marius,

I hope you will find some helpful information.

Good luck!

Rainer