Display monthly chart line until certain month

Fri, 07 Jun 2013 06:05:17 GMT

Hi,

I'm displaying a monthly chart, (Dimensions = month, Expressions=sum of price), which showing from January to December.

If the user input ReportMonth = May, the lineA should display from January - April values only while other lines still displaying till December.

How should i do this?

Re: Display monthly chart line until certain month

tresB — Fri, 07 Jun 2013 09:00:34 GMT

you have to take the input into a variable and then you have to use set analysis in the SUM expression to say that month<$Variable.

Hope this helps.

Thanks.