Static Trend Line - Sales Goal

[TLeather]

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.

[jmartineze · Accepted solution]

Hi, try to declare one varible with the increment value and use the expression  if(RowNo()=1,0,$(vName)) and press acumulate option.

J.

[TLeather]

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]).