Suppres some months on a time dimensions

[#1]

Hi all

I have a bar chart with a MONTH dimension and 2 expressions.

The fisrt expression is the the incomming ($$$)

The second  expression is the "predicted" ($$$)

What I need is to supress current month year, i.e (jan, feb) and show only the other (mar, apr, may, jun, jul, aug..... and so on)

Do you guys have any clue on how to suppres some months on a time dimensions???

Thanks ...

[swuehl]

If MONTH dimension was created using month() function in the script, you could create a calculated dimension like this to limit your MONTH dimension values:

=if(MONTH > month(today()), MONTH)

You could also use a set expression to achieve the same, but you would need to apply the set analysis to each expression in your chart, something like

=sum({<MONTH = {">$(=month(today()))"}>} incoming)

hope this helps,

Stefan

[v_iyyappan]

Hi,

     Use the Expression like this,

     =if((Year) > Year(today()) OR Month > Month(today()), Sum(incoming))

Regards,

Iyyappan