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

    Unique comma seprataed values instead of cloumn wise


      Hi all,


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




      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