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.
