6 Replies Latest reply on Oct 17, 2018 12:37 PM by Dakota Snyder

    Filtering concatenated data

    Dakota Snyder

      Hi everyone,

       

      I have a field in my data, regional concatenate, that I'm using for segmenting. There are 7 different possible values for this field, below.

      • Americas
      • AmericasEMEA
      • AmericasAPAC
      • AmericasAPACEMEA
      • EMEA
      • EMEAAPAC
      • APAC

       

      Example data below, I can't share the workbook due to client sensitivity

          

      Client
      Regional Concatenate value
      AAmericas
      BAmericasEMEA
      CAPAC
      DEMEA
      EAmericasEMEAAPAC

       

      Is there a way to create a filter with 3 options: Americas, APAC, and EMEA. And when I select Americas I would see Clients A, B and E?

       

      Thank you,

      Dakota