Sales selected months last year

[annabergendal]

How can I get sales for selected period last year?

If user selects 2015-03, how can I get sales for 2014-03?

See attached,

Thanks!

[tamilarasu]

Then Try,

sum({<YeasrMonth={$(=Concat(Chr(39)&Date(Addmonths(Date#(YeasrMonth,'YYYY-MM'),-12),'YYYY-MM')& Chr(39),','))}>}Sales)

!

[annabergendal]

Thanks tresesco and Tamil!

Your idea of defining an interval in the variable works!

Thanks to both of you, and also others who replied to this.

BR

Anna