Limit Bar Chart to 5 years

[Trey]

Hi - I have a simple bar chart that has "Years" for the dimension and "Number of incidents" as the measure.

My expression for years is =(Year([DOL - NOTIFICATION]))

My data for Years goes back to 2003. Currently, this expression shows all years dating back to 2003. I would like to limit this bar chart to the current year plus the last four. I'm having trouble finding an expression that will do this. 

Any ideas?

Thanks

[chaorenzhu]

use this set expression in your measure:

{<years={">$(=max(year)-5)"}>}

[Trey]

Thanks, but when I use   ={<year={">$(=max(year)-5)"}>}  it says there is garbage in the expression after =. Thoughts?

[chaorenzhu]

What expression are you using to calculate "Number of incidents"? Say it's sum(num), then just write =sum({<year={">$(=max(year)-5)"}>} num)