Calculated Field in Pivot Table

  • Thread starter Thread starter Tamir
  • Start date Start date
T

Tamir

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

Thanks,
Tamir :-)
 
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.
 
Back
Top