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
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
