PowerPivot - Combine Actual and Forecasted Values

[smallwood0507]

Hello - we have revenue reports that flow in periodically during the month. Until revenue in reported we use a 3 month forecast, once it is reported it is replaced with the actual amount. Currently we are using a formula such as =if(index(Rev Report),match(Customer Name),Match(Report Month)>0, return the value, average(C3:E3). We would like to use powerpivot to create as the report is manually updated. Is this possible?

Thanks!

 

[scottsen]

Yes, it is certainly possible. I suspect if you google for "powerpivot budget vs actuals" you will get some hits on PowerPivotPro. Generally the problem is the mismatch in time granularity... but that is a solvable problem