Set Analysis with <=

[wnorwood]

How can I make the following a <= the Max(Year)-1??

sum( {$<Year = {$(#=Max(YearMonth)-1)}>} Sales )

Or, to be more precise, I am trying to get to >=Max(Year-3 and <=Max(YearMonth).

Any assistance is appreciated!

Thanks.

[wnorwood]

Finally! Answered my own question... here is how I got there:

=sum( {$<test = {">=$(#=Max(test)-3)<=$(#=Max(test)-1)"}>} Sales)