View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Simon Simon is offline
external usenet poster
 
Posts: 172
Default Pivot Table Calculated Fields

Hi I have a pivot table with one data field which is "Revenue". On the pivot
table I've split the revenue by the Ledger field which holds the values of
"Actual" or "Budget". I want to be able to add a third field in which
effectively is Actual - Budget, is this possible? If so how would I do this?

Is it possible to change the Grand Total Field from Grand Totalling but to
do a subtraction of the Actual - Budget?