Add a functionality to Pivot Tables
It would be great to put a TEXT field on the value and look all possible values CONCATENATED
Kenneth Barber commented
Right now, the only way to do this is to use the CONCATENATEX function in Power Pivot. It would be nice to not be forced to resort to this.
Tom C commented
This would be very, very useful. I have wanted to do this on multiple occasions.