4 Replies Latest reply: Nov 26, 2012 3:18 AM by Anton Gustle RSS

    Customers that have not bought anything within

      I have a salestable with saledates and customerid.

       

      DateCustomeridSalesAmount
      2012-06-120015
      2012-06-070025
      2012-04-2900110

       

       

      By selecting dates I want to show in my graph every customer that have purchased anything in the selected period BUT have not purchased anything within 3 months prior to the chosen period. How can I do this?

       

      In the example table, If June 2012 is selected, only customer 002 should be counted.