How do I display comments (words) as my data in a pivot table?

J

jgirl2

I have some data that requires the following in a pivot table, in this order:

Store name, date of call, comments from the call. In other words, store name
and date of call are columns, and we need the comments to be the data. These
comments are non-numeric and I want them to come in as they are entered in
the database rather than meaningless numbers. Any ideas?
 
T

Tim879

Data items in the pivot can only be text. You can add the comment
field as a Row item and it will display you comment accordingly.

Excel automatically assumes anything in the data area should be
summed, counted, etc.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Change a great number of words in word files, with a macro as short as possible. 5
Dealing with a Pivot Table (when I don't want to) 0
How can I view comments in a pivottable? 1
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added a 0
Data missing in field in pivot table 1
Removing comments in a pivot table 1
SUM & OFFSET & PIVOT TABLE?? 0

Top