Open Project Count Prediction for upcoming weeks

[Anonymous]

Hi All,

I have Combo chart which has two dimension first is week Number and second is flag which has three values in it like RED,GREEN and BLUE.  RED and GREEN are the bar . BLUE indicate a line style.

RED are Incoming Project Count , Green are Moved out Project Count and Blue indicate Open Project Count all are per week .

I need to find the Open Project Count Prediction for upcoming weeks, for that we have data of closed Project Count as a new column for upcoming weeks.

Current Week in this Example is CW42 -18.

Till Current Week directly show the OPEN PROJECT COUNT Values , only for Next to Current week need to show

CW43-18 = above (OPEN PROJECT COUNT) - CLOSED PROJECT COUNT . Then it is like Trailing output for

CW44-18 =  CW43-18 - CLOSED PROJECT COUNT ,   CW45-18 =  CW44 -18 - CLOSED PROJECT COUNT , Etc....,

Note all the Prediction values need to be comes under BLUE FLAG.

Please help me on this . Thanks in advance