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

[paulyeo11]

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

[paulyeo11 · Accepted solution]

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