8 Replies Latest reply on Sep 27, 2016 1:28 AM by lei.chen.0

    Calculate growth rate on Actual + Forecast

    Morgan DUARTE

      Hello,

       

      I'm having a dashboard with 2015 and 2016 actual revenue (Up to July) and 2016 3 months forecast (Aug, Sep, Oct) set as 2 different dimensions.

      I would like to calculated the YTD growth, including the 3 months forecast.

      July YTD actual + Aug/Sep/Oct forecast compared to last year Oct YTD

       

      And ideally, the calculation should stop at Oct YTD. (As I don't have yet forecast for Nov and Dec)

       

      I've tried to sum first the actual + forecast, then do running sum, but with no success. (Might be doing it wrong)

       

      Any idea how to do it?

       

      Here is a sample workbook.

       

      Big thanks !