Not all the years

[#1]

You see the years 2002 - 2015, but I only want to see the years 2012 - 2015 how can I fix that?

[rubenmarin]

Hi, you can use an expression in multi-select box, ie:

=If(Year>2012, Year)

or

=If(Year>=Year(Today())-3, Year)

[marcus_malinow]

You'll have to limit the data you're loading.

In your load script you can use criteria such as 'where year(YourDateField) >= 2012'

[buzzy996]

try this on ur  year field on multi box  properties

=If(ur year field>='2012',ur year field,null())

[prieper]

Why? When there are data behind, it might be shown. If no data behind, might be limited in the script.

Anyhow: you may use an expression in the listbox:

IF(YearField >= 2012, YearField)

HTH Peter

[marcus_malinow]

Correction - as per Ruben's suggestion you can use a calculated dimension, so you don't have to limit the data you're loading.

However, if you're not going to allow it to be selected, why bother loading it?

[#7]

Here you go