1 Reply Latest reply on Apr 26, 2017 8:41 PM by Shinichiro Murakami

    How to identify people having purchase record last year and go to check if they purchase this year or not

    baron li

      Te date set looks like this

       

      YEAR        CONSUMER  PURCHASE

      2015                 A                   APPLE

      2016                A                   APPLE

      2015               B                   xxxx

       

      I want to first identify those who have purchase record in 2015 (A and B)

      and go to see their purchase behavior in 2016 (A only)

       

      I can achieve the first step, but when I cross the filter with 2016, the data shows nothing