2 Replies Latest reply: Oct 16, 2016 7:51 AM by David Guštin RSS

    Calculate returning customers

    David Guštin

      Hi,

       

      Please help.....

      I want to calculate how many products bought return customers from last year in this year, regardless SALES_AGENT.

      Should be 7 products... I can't figure out how to use SET analysis :-(

        

      CUSTOMER_IDPRODUCTQUARTERYEARSALES_AGENT
      1FRUITQ22015JOHN
      2BEERQ22015JOHN
      3BREADQ22015JOHN
      4EGGSQ22015JOHN
      5PAPERQ22015JOHN
      1BEERQ22015JOHN
      1EGGSQ22015JOHN
      2EGGSQ22015JOHN
      4FRUITQ22015JOHN
      1FRUITQ22016JOHN
      1BEERQ22016JOHN
      1EGGSQ22016JOHN
      2BEERQ22016GEORGE
      4EGGSQ22016WILLY
      4FRUITQ22016WILLY
      4BREADQ22016WILLY

      6

      BREADQ22016MARTHA
      6EGGSQ22016

      MARTHA

      7BEERQ22016JANE
      7PAPERQ22016JANE

       

      Thanks!