how to show selected year

[davinfrost]

hello,

i want to ask, how to show selected years, because i wanted to show 2020,2019,and 2018

 sum(
{<
FLAG_DB={'1'},
Year={'$(=max(Year))'}
>}
AMOUNT)

can i use 2 "Year" in 1 condition? for example Year={'$(=max(Year)),Year={'$(=max(Year)-1)'}  ??

if yes, how to?

thanks

[tresesco · Accepted solution]

You can with a bit modification, like:

Year={'$(=max(Year))', '$(=max(Year)-1)' } 

[Vegar · Accepted solution]

I might be missunderstanding you, but your header is "how to show selected year".

If you want an expression to reflect your selection you don't need to create a modifier for the Year dimension.

Your can try to do like this. 

=sum({<FLAG_DB={'1'}>}AMOUNT)