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

    Calculate growth rate on Actual + Forecast

    Morgan DUARTE



      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 !