pivot table to display the value instead of a summary

J

Jinghui

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

Debra Dalgleish

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