Actual vs Target

[Anonymous]

Hi,

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 ??

Message was edited by: Hat p

[sunny_talwar]

You want to do this in the script or front end? Also, would you be able to provide the raw data to test this out?

[Anonymous]

HI Sunny,

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.

Thanks for your response.

[sunny_talwar · Accepted solution]

Check if attached is what you wanted?

[Anonymous]

Thanks Sunny. Really helpful and got some experience from you..