Show the sum of the past 12 months

[Theo_Westseit]

Hello Guys,

im looking for a way to show the sum of the past 12 months....
Somehow, the formula doesnt work:

Sum({<Date={">=$(=(Monthstart(addmonths(Today(),-12))))<=$(=MonthEnd(addmonths(Today(),-1))))"}, Country={"Italy"}>}Sales)

The retrieved values are not the correct result...their 10x times higher...as if they were multiplied with something...

Any ideas?
Thanks!

[edwin]

i suggest start with a simple table where you have monthstart of date as dimension and just do a sum for Italy.  that could lead you to the issue 

[vinieme12 · Accepted solution]

As below , replace YYYY-MM-DD to match the format of your date field

=Sum({<Date={">=$(=Date(Monthstart(Today(),-12),'YYYY-MM-DD'))<=$(=Date(Monthend(Today(),-1),'YYYY-MM-DD'))"}

, Country={"Italy"}>}Sales)