Add a column to calculate remaining budget

[ChemChick]

I have a PivotTable that shows expenses across departments. Each department has a set budget for the entire year. In addition to the grand total that shows how much each department has spent, I would like a column that shows how much of their budget is remaining. For example, the DA department has spent $129.78, and their budget for the year is $1500, so they have $1370.22 remaining. I would like to do this for all the departments. I've included a screenshot of what my current PivotTable looks like right now.

 

[Swayzy]

Look into using a power pivot were you Link actuals data with budget. Search YouTube for something like power pivot budget vs actuals. And you can then very easily do percent measure showing budget vs actuals.