Forum Discussion
Pivot tables cannot show text? That is pathetic
I have been a software developer for 5 years. I am pretty familiar with SQL and using pivot tables in it, and thought it would be a breeze to do so with Excel. I load my data into the sheet, format t...
I believe Pivot Tables can show text in the values section if you create a measure using DAX. See Mr. Excel video https://youtu.be/IiFzVInI5sg Let me know if I misunderstood something.