1 Reply Latest reply: Mar 16, 2014 7:20 AM by Paul Yeo RSS

    Unable to make my chart using load script Flag on CY sales not YTD sales.

      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