The short answer is you can't. Pivot tables are designed to aggreaget data in
a hierarchy. Text does not aggregate. You can place the text in the row or
column headers and get counts so of those text values in the data area.
Thank you so much for your quick response! I had searched the help and web
and this was my final attempt to find the answer that I was looking for - but
alas.....apparently no can do!
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.