2 Replies Latest reply on Aug 26, 2016 11:52 AM by mary.quinn

    Combine Line Items

    mary.quinn

      I have a filter list of items in a report.  If I select item A and item B from the filter list it displays them on separate lines.  Is it possible to combine line items to one line, separating them by a comma?  Goal is to get all the data to display on one line.  Example below.  Thanks!

       

       

        • 1. Re: Combine Line Items
          David Li

          Hi Mary! You can clump together the Item Name or Item Description together on one row by adding the field to the Text marks. Then, you can edit the Text mark to add in the comma (though there will be an extra one at the end). However, I can only get this to work for one of the fields per sheet, so you might need to just do this in a dashboard and put the sheets next to each other so they look like they're on the same line.

           

          • 2. Re: Combine Line Items
            mary.quinn

            Thank you, I will give that a try!