10 Replies Latest reply on Jul 14, 2013 10:59 PM by Steve Martin

    Forecast to intercept reference line

    Steve Martin

      Hi All,

       

      This may have been answered before and in my haste I may have missed it but what I am trying to pull together is a chart to show when (forecast) the current sales shall cross the pre-defined reference point.

       

      The attached workbook using Superstore sales, I have a parameter allowing a user-defined value [in this instance I am using a value of 45m] to draw the ref line, switching the Order Date (years) between continuous and discrete seems to make no difference in allowing me to use the forecast though I suspect that this is more to do with me using the running total on the sales.

       

      Can this be done and can it be done to include the running total which is a big seller or