Trendline dissapears while making a selection

[bell_byloli]

hello all,

i have a combo chart which shows the last 6 months revenue based on the latest month . Dimensions are Month and region(Asia, europe and america), the chart is plotted expressions of revenue for bar chart and a line . however in default view, based on expression

sum ({<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"}>} (revenue))

i am able to view the trendline. However when i make a selection of the month , the chart shows the 6 months data from the month selected, however it does not show the trendline, it just shows a symbol over the selected month(diamond).

Please Can any one suggest how we can view the trendline for any selection.

[bell_byloli]

hello Sundarakumar , thank you so much for your help, i have a smiliar issue with one more chart please find it attached. here i am trying to calculate the servie levels. it doesnt seem to work.

aggr(count ({1<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"},[servicelevel]={1}>} [servicelevel])/

count ({1<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"}>} [servicelevel]),Month)

[bell_byloli]

sorry i overlooked something. it works perfectly fine. Thank you for the help.

[sundarakumar]

Ok thanks..