Jorge

Posts: n/a

How can I change the default way pivot tables summarize by

By default, pivot tables summarize data by "Count". Is there a way to set the
default as "Sum", which seems to be more widely used.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Blank Cells in Pivot Tables	Greg	Excel Discussion (Misc queries)	1	March 16th 05 09:23 PM
Macro for Pivot Tables	Thomas	Excel Discussion (Misc queries)	1	March 15th 05 01:03 AM
How can I change the default settings for pivot tables in Excel? .	KyWilde	Excel Discussion (Misc queries)	0	March 9th 05 11:33 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot.	stvermont	Excel Discussion (Misc queries)	1	February 17th 05 01:34 AM
How to change default page setup for pivot tables?	bobs	Excel Discussion (Misc queries)	1	January 5th 05 09:42 PM

All times are GMT +1. The time now is 03:02 PM.

About Us

"It's about Microsoft Excel"