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.

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.



Posted by Scott on June 11, 2001 3:36 PM

Thank you very much!