One of the most frustrating things when creating a Pivot Table is a value field. The Pivot Table doesn’t automatically show up in Values, and when you drag it there, it shows up as a Count and not a Sum.
The problem is that the field contains alphanumeric values, rather than just numeric values. When Excel isn’t “convinced” that your field contains all numeric, this happens.
Try the T function in your source data to uncover hidden text values T(cell ref). If it’s a numeric value, it will return a blank. If it’s not numeric, it will return the text (including numbers stored as text).
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/34252/one-of-the-most-frustrating-things-when-creating-a-pivot-table-is-a-value-field "
- Productivity plus: Retool with new Internet Explorer tricks
- Excel: Find peace with merged cells and calculations--two natural enemies
- Finding characters in Excel cells
- Is the report you print out in Excel clear until you get to page 2?
- Always open the same workbooks to do a task in Excel? Consider creating a Workspace