| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
You can't display text fields as text in the data area. You could add
the field to the row area, where the text will be displayed, then use another field in the data area to obtain a count of the occurrences. Murray Snedden wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Conditional Formating on calculated data in a pivot table | Excel Worksheet Functions | |||
| HOw do I display text in the data field of the pivot table, inste. | Excel Worksheet Functions | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
