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.

[Nicole-Smith]

Try adding a 1 into the set analysis in order to ignore the selection:

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

[bell_byloli]

thanks Nicole , i tried this option but i am still unable to the get the trendline when selecting a month

[sujeetsingh]

Try using if statement

[bell_byloli]

hey Sujeet thanks , i am not sure if i follow your method.Could please provide an example.

[sundarakumar]

Hi Belliappa,

R u using single expression to show both line and chart or two different expressions?

and Plese check in which field( "Month" or "Month new year") u r making the month selection?
Please try to post a sample or screen shot of ur chart and expression tab...

-Sundar

[bell_byloli]

hello Sundarkumar, i have uploaded a sample file.

[sundarakumar · Accepted solution]

Hi Belliappa,

PFA.

It is working now.

-Sundar

[bell_byloli]

Thanks so much Sundarakumar..!

[sundarakumar]

Hi Belliappa,

While working on your app, i did some changes for calculating the dimension, hope it will help your development.

PFA.

Hope this helps.

-Sundar