Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi All
I just found the solution , i change the chart to combo , and i set the % line as secondary axis.
Now it look great.
Paul
Hi All
I just found the solution , i change the chart to combo , and i set the % line as secondary axis.
Now it look great.
Paul