Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to add a trend line to a combo chart showing monthly sales compared to an annual sales goal. The value of the annual sales goal is a static value (i.e. Annual Sales Goal = $120) and therefore should start at $0 then increase by a value of $10 for each month throughout the year. I have reviewed the forum comments regarding calculated trend lines but none appeared to address the static need. Any offers of assistance would be greatly appreciated.
Hi, try to declare one varible with the increment value and use the expression if(RowNo()=1,0,$(vName)) and press acumulate option.
J.
Hi, try to declare one varible with the increment value and use the expression if(RowNo()=1,0,$(vName)) and press acumulate option.
J.
Thank you J.
I appreciate you quick reply. I added a multiple by month to get the results I was looking for i.e. if(RowNo()=1,0,$(MonthlySalesGoal)*[SaleDate.autoCalendar.Month]).