Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
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
put this set analysis statement in each expression:
{<Year={'>$(=(max({1}Year)-2))'}>}