Dynamic min and max Y axis using aggr commend

[paulyeo11]

Hi All

Can some one advise me how to make my GP% chart dynamic changing max and min value ? as now i need to manually change it .

My expression as below :-

(

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

-

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1

)

/

sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1

Enclosed my QV doc.