1 Reply Latest reply on Oct 19, 2018 1:02 AM by Joanna Pakes

    Filtering duplicates

    Magdalena Janiak

      How can I filter only those Ids which have 2 brand IDs?

      (In this case 59)

        • 1. Re: Filtering duplicates
          Joanna Pakes

          Morning Magdalena,

           

          If you Count (Distinct) the Brand like I'm doing here with Order ID

           

           

          And then drag the field into filters and select Count (Distinct)

           

           

          Then apply the ranges you want. eg. At most = 1

           

           

          That should filter out Id 59.

           

          Thanks

          Jo

          1 of 1 people found this helpful