3 Replies Latest reply on Feb 23, 2018 12:24 PM by Norbert Maijoor

    Trying to capture existing customers vs new customers over 2 periods

    Robert Priewe

      Hi, this might be a simple question but for some reason i cant figure it out. I have a simple table like this, in Q4 customer 5 is a new customer and customer 1 disappears:

       

      Customer Quarter
      1Q3
      1Q3
      2Q3
      2Q3
      2Q3
      3Q3
      4Q3
      4Q3
      2Q4
      2Q4
      2Q4
      3Q4
      4Q4
      4Q4
      5Q4
      5Q4

       

      How can i create a filter to automatically catch customer 5 (and all others in a big dataset) so i can use it as a filter? In my dataset i'm always only comparing 2 quarters which are selected with a parameter.

       

      Thanks!