View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Calculated Field in Pivot Table

EXCEL 2007

Click in the Pivot Table / PivotTable Tools / Options / Tools group /
Formulas / Calculated Field / complete the Name: field / enter the Formula:
field and remove the 0 / Click the first Field: you wish to add / Insert
Field / enter the + sign / Click the second Field: you wish to add / Insert
Field / OK

If my comments have helped please hit Yes.



"Tamir" wrote:

Hi,
How can I create a coloum in a pivot table that is the sum of two others
coloumns?

Thanks,
Tamir :-)


.