Pivot Table: Grand Total/Difference for Rows

[Paella1]

I use a pivot table to summarise data in two columns: Actual and Budget. If "Grand Totals for Rows" under PivotTable Options is checked, the final column displays the sum of the two items for each row. Obviously, adding a budget figure to an actual is meaningless. However, if this column could be configured to display the difference rather than the sum, then it would be anything but meaningless. Is this possible?

 

[texasalynn]

create a calculate field to perform the difference

 

[Datsmart]

This link will demonstrate how to include a calculated field in your pivot table.
http://www.datapigtechnologies.com/flashfiles/pivot4.html

 

[MikeDBMan]

This does not work this way for Excel 2010. I can't get row grand totals to show. Suggestions?