pivot table to display the value instead of a summary
 

How do I get the Pivot Table to stop counting/summarizing and just display
the cell data? I am using Excel 2007.

pivot table to display the value instead of a summary
 

Pivot tables are designed to summarize data, and won't show text from
the source table in the Values area.
You can summarize by Min or Max, to show the high or low values, instead
of summing or counting.

Jinghui wrote:
How do I get the Pivot Table to stop counting/summarizing and just display
the cell data? I am using Excel 2007.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html