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

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.
------------------------

[fancypants]

Excellent instructions! Not too fast, and not too slow. And none of the important steps are glossed over. It is easy to watch it over and over to learn it, without wasting time or feeling that I need to skip ahead.

[hobohunter]

I cannot describe how much time you have just saved me, this excellent!

[Mauserratte]

Damn this was the best excel video I ever seen. Right to the point without any filler.

[ewawojciech-bube]

Thank you !! I was so overwhelmed with my new job and so stressed and your calming voice and simple instructions shows me that there is hope !! Have a wonderful day Sire! As you have just made mine ! :)

[Mstrmnd_]

This should be the most watched video in youtube! 😂
Thank you so much, friend!

[Odiiaras]

Additional tip for anyone using this trick: if you are doing this over a particularly large set of data, first build the pivot table off of a smaller sub-set of data in the table, perform all the steps, and then delete the "Grand Total" sections before adding the rest of the data to the table. The Grand Total sections can potentially run into the issue of exceeding the character limit for a single cell in Excel (32k), which will cause the Measure to fail out when added to the Values section. After you have cleared that out, copy the rest of the data into the table and refresh the pivot table, and you should be all set.

[nabanitadutta]

I just can’t explain how much relieved I’m now… I was tryna fix it since evening so hopefully I’ll be able to finish my project by Sunday. Thank you.

[trabin]

Great Video. I"ve been looking for this feature for months! Very well described.

[VeronicaSanchez-qtzf]

I've been wanting forever to learn how to do this. Finally!!! Thank you

[lijunchen]

This is a very useful video. I had thought text values could not be used in a pivot table. I used to categorize texts into numbers before using them in a pivot. This video proved me wrong. I wished I had known this earlier. I don't know why there is little information online about this useful feature.

[IvanCortinas_ES]

As always, excellent quality and knowledge in your videos. Thanks for this video with DAX, Chester!!

[vladisan]

This is extremely helpful and awesome as a video. Explanation and skill are next level.

Very useful, thank u for sharing. And the "values" trick, was EXTRA helpful

[tsamt]

Been banging my head trying to work this out, thank you soooo much!!!!

[mariamalnauimi]

Don’t know how to say thanks


really it is so helpful million thanks 🙏🏼

[VicSMeIsTeR]

Literally saved my life,
thousand thanks

[jenali]

Thanks, this helps me a lot with my reconciliation report. 👍👍👍

[shraddhabaeet]

Loved it! In the short time top notch! 💯💯❤❤

[trackspin]

Thank you very much. I have been searching the way to express lists in pivot. It's so much helpful.

[aileneiraluca]

Great video! Thank you for the explanations!