| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
how can I get my pivot table to show the value in a cell not the
count?....(the actual data of the cell)...thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table
To begin, you need to make sure the cell type is number, not text
then, you can change the summation by right click the field in the pivot table layout, and change it to Sum instead of Count JH "jcheko" wrote: how can I get my pivot table to show the value in a cell not the count?....(the actual data of the cell)...thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Hybrid Mode
