Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have this Expression from chart A :-
money(
Sum(
{<Year={'>$(=year(today())-2)'}>}
sales/1000)
, $(vMoneyFormatK))
I get 2014 and 2013 sales trend. My issue is for 2014 sales i only want to plot YTD sales which is from Jan till Feb. and not Jan till March.
In order to make my current year sales only display YTD sales , i modify above to below expression :-
money(
Sum (
{<Year={'>$(=year(today())-2)'}>}
if(YTD,sales)/1000)
, $(vMoneyFormatK))
Now my Chart B , only display 2014 sales , and not display 2013 sales line. may i know how to make 2013 sales line display ?
Paul
my qv doc