Question: can pivot tables show text?
Answer: Introduction. Usually you can only show numbers in a pivot table values area, even if you add a text field there. By default, Excel shows a count for text data, and a sum for numerical data.