Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I would like to limit an expression to only show the last 3 years of data (present year and two years prior).
This is working:
sum({<year = {">=2014"}>}value)
However, I would like to replace {">=2014"} with an expression such as {">=year(now())-2"} or {">=max(year)-2"} however neither is working.
Is this possible and if so, what is the syntax?
Thanks in advance,
Will
Try this
Sum({<year = {">=$(=Year(Today()) - 2)"}>}value)
Note: Since we are in 2017 you will see everything above 2015 here....
Try this
Sum({<year = {">=$(=Year(Today()) - 2)"}>}value)
Note: Since we are in 2017 you will see everything above 2015 here....