dynamic set modifier expression

[william_ericksson]

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

[sunny_talwar · Accepted solution]

Try this

Sum({<year = {">=$(=Year(Today()) - 2)"}>}value)

Note: Since we are in 2017 you will see everything above 2015 here....