Showing MTD values

[deepakqlikview_123]

Hi All,

Currently I want to show the values for max year -2 in a manner that whenever i can select apr values should be jan+feb+mar for max year -2

=Sum({<Year={'$(=(max(Year)-2))'},Month_Num={'<=$(=max(Month_Num))'},[Mining New]={"Mining"}>}Total)

But my expression not working whenever i am selection month.

Can you please suggest what changes i need to do in expression.

[vinieme12 · Accepted solution]

if you have Year as a dimension, then use below

=Sum({<Year={">=$(=(max(Year)-2))"},Month_Num={"<=$(=max(Month_Num))"},[Mining New]={"Mining"}>}Total)

[#3]

Since you select april using the month field you have add it to the experssion :

=Sum({<Year={'$(=(max(Year)-2))'},Month_Num={'<=$(=max(Month_Num)-1)'},[Mining New]={"Mining"},Month>}Total)