Pivot Table Questions

[pagrender]

Hello,

Is it possible to replace the Grand Total column with a "difference" column?

I'm using the "Show Report Filter Options" from Excel 2010 to create a bunch of tabs based on the different values in the report filter so I would like to have my Pivot Table automatically calculate the difference instead of the total.

My Pivot Table has three columns; Employee Name (this is the Row label), Budget, and Actual. The Budget and Actual columns are based on a field called "Budget or Actual" and is considered the Column Label. Excel added the fourth column called Grand Total. This column is adding the Budget and Actual columns. I would like to subtract the two columns to show the difference. Is that possible (other than adding a column that says B5-C5 or changing the source data to make the Budget negative)?

Thanks,
Pete

 

[GlennUK]

Insert a calculated field for what you want. ( In Excel 2007 it's PivotTable contextual tab Options/Tools/Formulas drop-down ... Calculated Field, then type a suitable field name, with a formula of what you want, using the existing fields )