Forum Discussion
Pivot Table Budget Help - Difference between Actual and Estimate
Hello! This seems like it would be pretty simple but I can't figure it out! I have a last of events in a tab with all the basic info (name, date, etc.) then estimated costs and actual costs. ...
lindsayS_TR May I suggest that you use both a structured table for your events combined with a pivot table. Adding events will automatically expand the data source for the pivot table ("pt"). Just refresh after new events have been entered.
To include the variance between Actual and Estimate, you can add a "Calculated Field" in the pt.
The attached file contains a working (though very simple) example.