12 Replies Latest reply: Jan 30, 2014 12:55 PM by Christian Lauritzen RSS

    Count where NOT in a dimension but is in the previous dimension

      Hi All,

       

      I have attached an example data set.  What I want to do is for each week, count distinct customers who were NOT present in the week of the dimension but WERE in the previous dimension.

       

      I am hoping to do this using set analysis with the use of no aggr or if statements as these are computationally restrictive for large data sets.

       

      Does anyone have any good ways to do this?  The problem obviously is how to count people who by definition are not present in that week. 

       

      I can't use the ABOVE or BELOW functions because I want to count distinct people based on Customer number.

       

       

      Cheers!

       

      GPC