12 Months Set Analysis

[Anonymous]

Trying to show the some for the past 12 months based on the current selections .

Dimension : YearMonth

Expression :

sum({[Year & Month]=,[Fiscal Year]=,[Date ]= {">=$(=vMinDate) <=$(=vMaxDate)"}>}[Amount])

The result is if I select yearmonth = aug18 it shows the sum of all possible from aug18 to the very last month in the QVdD. Even though I am limiting the Date to 12 months using the min amd max.

How can I show only the last 12 months?

[Anonymous]

Changed the expression order for modifier and it worked :

sum({[Date ]= {">=$(=vMinDate) <=$(=vMaxDate)"},[Year & Month]=,[Fiscal Year]=,>}[Amount])

[lironbaram]

hi

what expressions are you using in the variables