1 Reply Latest reply on May 7, 2012 9:01 AM by Tracy Rodgers

    how to set up sum with "or"  instead of "and" in matrix

      Let’s say I have 5000 customer records and I have two y/n
      flag to indicate if they are cat or dog owner. I know that there are 1000 cat
      owners and 3000 dog owners on the file and 500 are cat and dog owners. If I do
      a regular cross tab the system interprets the 2 fields as cat “and” dog – which
      returns a total of the records that have a cat and a dog = y –which is 500.  I am looking for a matrix that will show me –
      records with cat or dog but with subtotal by cat and dog - 
      Any suggestions?