In the pivot table, drag the Data button onto the cell that says Total.
There are instructions with a picture he

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

pm wrote:
below is a piece of my pivot table. My question is, how can I get the sum of
deduct in a column next to the sum of ext AWC? I want them side by side so I
can do a net of the two fields. Thanks for your help!


Vendor Data Total
A.T. & T.(M. ROTHMAN) Sum of Ext AWC 285.48
Sum of Deduct 0
AIRWELL FEDDERS NORTH AMERICA
Sum of Ext AWC 8,629.14
Sum of Deduct 0
AKAI Sum of Ext AWC 3,471.96
Sum of Deduct 0



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