I just need to calculate Actual vs Target by department wise. For Ex: If i select 2018 , I have sales for Jan, feb but for remaining months i need to put the previous month sales to know if we go with this sales trend whether we will meet the target. .
can anyone please advise how I should handle this ??
Please find the attached sample data. Here , i have sales for all the months in 2017 except aug 2017 but for 2018 i have till feb - I need to put the feb 2018 data for all the remaining month in 2018. it' can be either in script or front end.