Rolling Forecast Chart

tompatrick.ting
tompatrick.ting
in Modeling

Hello,

 

Is there a way I can create a line chart that connects the Actual data and the Forecast? 

 

Attached is the screenshot from Excel that I plan to create in Anaplan.

tompatrickting_0-1605691740767.png

 

Thanks,

Tom

Tagged:

Answers

  • Jitendra.Vishnolia
    Jitendra.Vishnolia

    Hey @tompatrick.ting ,

     

    You can bring Actuals and Forecast data in one common line item (applying If else condition on Time dimension) and then create a line chart.

    However, the line chart won't of 2 different colors as shown in excel. 

     

     

    ~ Jitendra

Categories