7 Replies Latest reply on Aug 29, 2013 1:27 PM by Michael Crow

    Delimiters to separate multiple text marks in a cell

    Michael Crow

      Any suggestions on how to add delimiters to separate multiple text marks in a cell? For instance, in the sample image
      below, I’d like to separate the different product category names with a delimiter like a pipe. I know that I could get some visual distinction by putting category names on color, but those colors would compete with color elsewhere in the dashboard, so it wouldn’t work for my purpose. I have also considered putting them in rows or columns, but need a more space-efficient approach. I suspect a calculated field might solve my problem, but I'm not sure how to approach it. Sample workbook attached, from which the image was taken. Suggestions very much appreciated.

      Product Categories by Customer.jpg