98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
Pivot Tables
Resolved · Urgent Priority · Version 2010
Tue 3 May 2011, 15:44Delegate Salmana said...
Salmana has attended:
Excel Intermediate course
Pivot Tables
Hi,
I am using pivot tables to convert a long column of data (with data for 53 african countries across 10 years) into a table with countrys in the row field and years in the columns field. When I drag the actual data to the values field it doesn't show the actual raw data. It only gives me the option of 'sum, count, average etc...'.
However some of the data-points are a "." and I need them to show as they are in the table. The closest I have got is using the Sum option however, for cells with a "." this returns a value of '0' in my table.
Is there anyway around this so that the "." cells show like ".".
Many thanks
Wed 4 May 2011, 10:18Trainer Anthony said...
RE: Pivot Tables
Hi Salmana, thanks for your query. Pivot Tables summarise raw data by definition, I'm afraid. There is no way to see the raw data on a Pivot Table, but you can "drill down" into the data but double clicking on totals. If the Pivot Table displayed the raw data itself it would simply be... a table!
Note that any "." data points in your source data will be intepreted as text by the Pivot Table which will make it default to the COUNT analysis. If you do need to return "." in the Pivot Table you might need a further tweak, possibly using the IF or VLOOKUP function to convert those values back.
Hope this helps,
Anthony
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. |
Excel tip:Using the Quick Access Toolbar in Excel2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
