Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
sorry i overlooked something. it works perfectly fine. Thank you for the help.
Ok thanks..