2 Replies Latest reply on Aug 16, 2017 5:07 AM by shwetha sarma

    Remove duplicates in string list

    shwetha sarma

      Hello, I'm trying to put a string list in tableau tooltip using this source:

       

      Creating a String List to Display in a Tooltip | Tableau Software

       

      However, I want to to show sub category in tool tip when I show the product list. (Some of the products are shared by same sub-categories. I want to remove these duplicates)

       

      *There are no duplicates in the dummy data attached. However, my data is different.

       

      Formulas used:

       

      1. { FIXED [State] : SUM([Sales]) }.

      2. '-' + ATTR([City (string)]) + '

      ' + PREVIOUS_VALUE('')

      3. INDEX() <> SIZE()