Forecast goals to meet Target

[#1]

Hello Everyone,

I am not sure how apt is the title of the discussion.

But I have scenario which is not really a  forecasting model but a target driven scenario . This is more of what the team’s monthly performances will be for the future months to meet the year end goal?

The attached sample is an actual export of my pivot. The customer 1 is missing YTD for both Metric 1 and Metric 2 until August 2016.

So I need to update -  what my team's performance should be for the month of September to December to meet the YTD goal? The numbers I want to populate in this pivot is marked as "?"  Any inputs will be highly appreciated.

Thanks

Devanjan