5 Replies Latest reply: Jul 31, 2014 2:35 AM by Mafaz Jaufer RSS

    How to add planed YTD on a chart?

      Hi,

      I have a chart as below where I want to show PLAN, Actual, YTD along with 2014 - 2015 (YTD). So I have used below query

      Sum({<Year = {'2014', '2015' }>}[Actual SPCD hit rate_CUTTING]/12)

       

      1. is the query is right?

      2. If that so, I don't want to show 0% I just want to show the line only where there is a value how do I do that?

      Eg: Line only on top of Jan, Feb and Mar

      Chart.png