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

       

      Capture.PNG

       

      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


      Thanks

      Vinay