Archive of Mr Excel Message Board
Back to Pivot Tables in Excel archive index
Back to archive home
Excell Pivot Table ???
Posted by Scott on June 10, 2001 5:49 PM
How do I use more than one summary function for a PivotTable data field? Where do you find this information?
My MOUS study book says to use the "Office Assistant" to find this information and I generally make a habit of printing out the answers when I find them for study notes.
I have not been able to find this despit many differnet queries.
Your advice would be appreciated.
Re: Excell Pivot Table ???
Posted by Mark W. on June 10, 2001 7:32 PM
Drag as may copies of a given field name to the
DATA area as needed. Double-click each field name
and choose the desired summary function.
Re: Excell Pivot Table ???
Posted by Scott on June 11, 2001 3:36 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.