How Can I Show Text in the PivotTable Values Area Instead of Numbers? | Display Unique Text Values

Download the featured file here: www.bluepecantraining.com/wp-...
In this video I am using PivotTables in Microsoft Excel. I want to display text in the values area of the PivotTable, instead of performing the default COUNT calculation.
To achieve this I am going to use a measure. The measure employs two functions CONCATENATEX and VALUES. CONCATENATEX as the name suggests joins the relevant text values in one text string. VALUES allows us to display unique values only.
------------------------