4 Replies Latest reply: Dec 3, 2013 12:14 PM by Christian Schlettig RSS

    'Or' Statement among different fields

      I'm trying to build List Box/Boxes where the users can make selection based on 'Or' statement from different fields. For example, to get count for IDs who are Male or HHI $200K+? Since there are so many fields that the users can dynamically select and build the target from, I can't create new fields to include 'Or' expression in - there's no way to exhaust the possible combinations. What should I do?

       

      IDAgeGenderHHI
      P115-24M100-150K
      P235-44F200-300K
      P355+FBelow 50K
      P435-44F300K+
      P545-54M200-300K
      P635-44F100-150K
      P725-34MBelow 50K

       

      Thanks!

       

      _______________________________________________________________

       

      updated with a sample data - how to make count to be either Pantene user or Dove user? Thanks a lot!

       

      消息编辑者为:Carol Song