Show Text in Excel Pivot Table Values Area
Usually you can only show numbers in a pivot table values area, even if you add a text field there.
To show text, you can combine conditional formatting with custom number formats. This works well, in Excel 2007 and later, if you don't have too many text options. In this example, there are 3 regions -- East, Central and West.
Website - http://techxls.ml/