After you add the calculated field, in the pivot table, drag the Data
button to the right, into the cell that contains the word Total.

There's a picture he

http://www.contextures.com/xlPivot02.html

Brennan wrote:
I have a pivot table and I would like to create some calculated fields as
columns, but I am only able to add rows within the pivot table. Any
suggestions on how to overcome this? Thanks all.

Brennan


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com