I tried what you said in the load step in the script editor and in the graph i have the message "no data to display".
After troulebshooting, i understood it is because of the formulas used in the expressions.
In fact, for each expression (each represented by 1 curve), i have a "IF" statement as below:
For 1st curve(2011 sales):
For 2st curve(2012 sales):
I assume that if a load only Month in the editor script QV could not perform the function YEAR() in the "IF" statement.
Now what is your advice to have only the month dimension in the graph and be able to do the "IF" statement depending the year 2011 and 2012.
thank you in advance
I got your issue.
Create another field
Year(Date) as Year.
Add this to inside the dimension. Now in your dimension there are two field Month and Year. Promote and demote the dimension to get your required result.
And in expression write Sum(Sales). No need for two expression, one will do.