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?
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.
Retrieving data ...