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.
