pivot table to display the value instead of a summary

  • Thread starter Thread starter Jinghui
  • Start date Start date
J

Jinghui

How do I get the Pivot Table to stop counting/summarizing and just display
the cell data? I am using Excel 2007.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Excel Pivot Tables 4
including zero values in a pivot table 2
How do I hide hide #REF! in Excel 3
Pivot table layout that popluates the row label in each row? 3
Refreshing Pivot Table on a protected spreadsheet tab 1
Date/Time issue with Pivot Table 3
Pivot table formatting 3

Back
Top