| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot table
How can I drag the source field to the data area instead of getting sum of or
count of the source field? Thanks |
|
#2
|
|||
|
|||
|
Pivottables are used to show numeric summaries.
You can count, sum, average, ..., but you can't show the actual text in that area. Jim wrote: How can I drag the source field to the data area instead of getting sum of or count of the source field? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
