Exclude data from dimension

[#1]

Hi !

My question is simple, but I got stuck with it. I've got a dimension (year) on a bar chart, but there is too many informations on it.

years= 2011,2012,2013.

I want that my chart only shows me the last two years instead of all the years, without having to select them in a selection list.

how can I do it ?

Thanks in advance.

[MK_QSL · Accepted solution]

Instead of year, use below expression in your list box expression

=IF(Year> Max(TOTAL Year)-2, Year)

Or

IF(Year> Year(Today())-2, Year)

[PradeepReddy]

Write the calculated expression... as suggested by Manish

=IF(Year_Field>=Max(Year)-1,Year)   ---Takes the 'max year' from the available data

or

=IF(Year_Field>=Year(today())-1,Year)  -- Takes latesr 2 years data including this year

[tobias_klett]

put this set analysis statement in each expression:
{<Year={'>$(=(max({1}Year)-2))'}>}