Generate text by slicer

[Excelnewcomer23]

Hi Guys,

i want to make excel pivot table slicer generate text in a cell when any slicer is chosen. Is it possible for me to do that?

Thanks

 

[rhombus4]

Copy the pivot table to another area and remove everything except the row field of the slicer.

Then use a textjoin formula in the cell where you want to show slicer values

I.e. =textjoin(", " True, z2:z20)