5 Replies Latest reply: May 21, 2018 11:23 AM by Vinay Vishwanatha RSS

    Cumulative expression request for combo chart

    Vinay Vishwanatha

      Hi All,


      could someone please help in providing cumulative expression for line graph (Combo chart) wherein it is should look as below


      This is the one which i am trying to replicate in QS




      and below is the original one...


      Capture 1.PNG

      as per the requirement i have to create below views


      Actuals cumulative = Only for the past months

      Forecast cumulative = Actuals as of past months + future forecast (e.g. Actuals P1-P3 + Forecast P4-P12)

      Show 1 decimal point

      Dimension used is Month (P1,P2,P3.....P12)

      Measures used are Actual, Budget and Forecast values