Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table Setup & Default Formats
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot Table Setup & Default Formats
Resolved · Medium Priority · Version 2007
Reply
Pivot Table Setup & Default Formats
How do you change the default setting for calculation type and cell format for results reported in a pivot table?For example, when I drag fields into the bottom right box of the pivot table field list wizard 'Values' it always defaults to 'Count' and 'general' format. I would like the default to be 'sum' and number format with no decimal places and comma separator. The data source is number format so I am not sure why it defaults to Count instead of Sum. I can change this manually but it is tedious when experimenting with different reports.
Thanks,
Francis
For upcoming training course dates see: Pricing & availability
RE: Pivot Table Setup & Default Formats
Hi Francis, thanks for your query. According to this:http://www.contextures.com/xlfaqPivot.html#DefaultSUM
...you can't change the default settings for the data fields. "If a field contains blank cells, or cells with text, it will default to COUNT. Otherwise, it will SUM. There's a feature that changes all the data fields to SUM, in my PivotPower add-in, that you can download and install."
Try checking the formatting of your source data. The fact that Excel is defaulting to Count makes me suspect the data itself needs reformatting. Cut and paste the data unformatted into a new worksheet, reformat as numbers, then create a Pivot Table from that. Let me know how you get on.
All the best,
Anthony
Mon 14 Dec 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Headers.. |
Choosing A Training Style To Suit You If you're tasked with sending your company to a training course, you'll need to learn about the different types - from e-learning to rolling out training across a whole company. Here are some ideas to consider when booking a training session... » Article: Microsoft training providers in london |
How do I keep headers at the top of each column so that as I scroll down the page they are still visible at the top? 
