12 Replies Latest reply: Apr 20, 2017 4:48 AM by Sunny Talwar RSS

    Nested Set Analysis - Customer bought in both time periods

    Samuel Lin

      Hello All,

       

      I thought this would be simple and read through many posts online still with no luck, but I know that I need to use nested set analysis to achieve this (?)

       

      I am trying to calculate in an expression (like in a Text & Image in sense) that the number of customers who bought in 2016 (between 01/01/2016 and 12/31/2016) also bought in 2017 (between 01/01/2017 and 12/31/2017).

       

      Is there a way to achieve this?

       

      Thank you!