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 :-)
.
|