0 Replies Latest reply: Mar 2, 2017 6:08 PM by Peggy Wells RSS

    Trying to create a annual view of results by adding field combinations<

    Peggy Wells

      I posted this previously with no reply but I know this should be able to work.  I'm trying to create a dimension using a variable that will reference a dimension & month combination but getting nowhere!  The table below is an example.  My model is quite larger than this, but this simple example is the problem.  I want to create a full year scenario called "Cur Fcst" that will pull Actual Jan, Actual Feb, 2+10 Forecast Mar-Dec.  How do I do that???


       

      ScenarioMonthRevenue
      PlanJan100
      PlanFeb200
      PlanMar300
      PlanApr400
      PlanMay500
      PlanJun600
      PlanJul700
      PlanAug800
      PlanSep900
      PlanOct1000
      PlanNov1100
      PlanDec1200
      ActualJan150
      ActualFeb190
      2+10 FcstMar250
      2+10 FcstApr275
      2+10 FcstMay345
      2+10 FcstJun415
      2+10 FcstJul485
      2+10 FcstAug555
      2+10 FcstSep625
      2+10 FcstOct695
      2+10 FcstNov765
      2+10 FcstDec835