In the Pivot Wizard, add another copy of the field to the data area
Double-click on the new field, and under 'Summarize by', choose one of
the functions.

SkoolGirl wrote:
How do I use more than one Summary function for a PivotTable data field?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html