Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Changed the expression order for modifier and it worked :
sum({[Date ]= {">=$(=vMinDate) <=$(=vMaxDate)"},[Year & Month]=,[Fiscal Year]=,>}[Amount])
hi
what expressions are you using in the variables