2 Replies Latest reply on Nov 19, 2018 10:57 AM by nilesh.patil.2

    Unique comma seprataed values instead of cloumn wise

    nilesh.patil.2

      Hi all,

       

      Following community post helped at certain extent to me for achieving comma separated values instead of column wise

       

      https://community.tableau.com/message/593042#593042

       

      But would like few additional set up in my report using the same solution. Can someone please confirm me on following problems?

       

      1) I want to repeat the last highlighted row (last row concatenated values of column) in red  against each row. Reason- I want to search for particular values to be available in the concatenated row then show only the data. I tried doing max /using LOD but already table calculations used for concatenate values

       

      2) is it also possible to only get a unique values in concatenated string? It seems that this particular example has all unique roles but looking for unique values in the last row.

      Concat Repeat row.JPG