2 Replies Latest reply on Jun 10, 2015 10:19 AM by Matt Lutton

    Hi All-

    Jeffrey A. Young

      I have 35 company id's- among whom a large customer list is distributed. I am trying to tie each company id to their relevant customers, so that when I filter my viz by that company id only their customers are pulled in.


      My best stab at it is below- but it doesn't work.


      Case [company_id]

      When 2 AND [Aggregate Customer Name] = 'A' OR 'B' OR 'C' OR 'D' OR 'E' OR 'F' then [Aggregate Customer Name]

      When 3 AND [Aggregate Customer Name] = 'G' OR 'H' OR 'I' OR 'J' OR 'K' OR 'L' then [Aggregate Customer Name]

      When 4  ….

      End

       

       

      Very Best,

      Jeff