12 Replies Latest reply on Aug 23, 2018 1:58 PM by Helen Wang

    Exclude values with multiple occurence

    Gurpreet Singh Goraya

      Hello All,

       

      I want to exclude values that have multiple occurrences. In the provided screenshot the highlighted events have multiple values of their ID and I want to omit them from Viz.I just want to show only those clientID who has only one id with 0 values.

       

      Worksheet attached herewith. Thank you in advance.

       

      GG