| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Summary | Excel Discussion (Misc queries) | |||
| Pivot table summary option--display list of values | Excel Worksheet Functions | |||
| summary sheet ? pivot table? | Excel Worksheet Functions | |||
| Display Pivot table summary in order of increasing time frame | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
Linear Mode
