Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can with a bit modification, like:
Year={'$(=max(Year))', '$(=max(Year)-1)' }
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)
You can with a bit modification, like:
Year={'$(=max(Year))', '$(=max(Year)-1)' }
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)