6 Replies Latest reply on Oct 2, 2012 4:24 AM by John Perry

    Filtering specific columns

    John Perry

      I'm trying to build a report that would show only new customers.  A new customer in this case would be someone who hasn't bought in the last two quarters.  In the example below, Customer B would be a new customer.

       

      Customer NameQ2Q3Q4
      Customer A$10$20$10
      Customer B$0 $0$20

       

      Does anyone know how to filter to show only customer who meet the pattern of $0 in Q2 and Q3 and a positive value in Q4?

       

      Thanks!