6 Replies Latest reply on May 28, 2013 2:49 AM by Willem Botha

    Filter single selection contained in either one of two fields

    Willem Botha

      I have two fields in my data that contain the same data type (A-Z). A customer can have a value in either, both or neither. If I want to filter all customers that have say A, G, I or P in Field 1 OR Field 2, and display all permutations, how do I do it?

       

      The only thing I've come up with is using parameters for the code selections, but it's not a great solution. It means I have to have a large number of parameter controls on my sheet as users might want to select any number of codes to include.

       

      Thanks in advance for any help!