Exclude value from dimention

[alec1982]

Hi,

How can I exclude a value from showing up in dimension

like the dimension in my case is Year([Fieldname])

And the field shows 2012  2013   2014    2015

I would like to exclude 2012.

Thxs,

[erichshiino]

Hi, Alec.

Are you using this dimension in a list or in a chart?

You can change your it a little bit to exclude 2012.

For example, instead of Year([Fieldname]), you can use:

= if ( Year([Fieldname]) > 2012, Year([Fieldname]) )

or

= if ( Year([Fieldname]) > year(today()), Year([Fieldname]) )

In a listbox, the result will 2013, 2014...

In a chart, 2012 results will be a in a line where Year is NULL.

You can hide this by checking the option 'Hide when value is null' on the dimension tab of your chart.

... you can also create a Year field, instead of using Year([Fieldname]) in your charts. this might increase the performance a little bit.

hope this helps,

Erich

[alec1982 · Accepted solution]

If(Year([Fieldname]) <> '2012', Year([Fieldname]))