1 Reply Latest reply: Mar 3, 2016 7:56 PM by PAUL YEO RSS

    How to set % on right side of chart and left side display sales and target ?

    PAUL YEO

      Hi All

       

      I try to add a % line to display % gap on sales vs target , my expression is working fine , but i am not able to make the % line appear on the chart .


      rangesum(above(
      sum({$<year = {$(=max({<sales = {'*'}>}year))}, month = {"<=$(=max({<year={$(=max({<sales = {'*'}>}year))}>} month))"}>} sales)/1000
      ,0,rowno())) /
      rangesum(above(
      sum({$<year = {$(=max({<sales = {'*'}>}year))}, month = {"<=$(=max({<year={$(=max({<sales = {'*'}>}year))}>} month))"}>} sales_target)/1000
      ,0,rowno())) -1

       

      May i know how to make the red line % line display on the right size of the chart , now is using left side , wrong scale .

       

      in my next post i will send my QS Doc

       

      Paul