1 Reply Latest reply: Jul 1, 2015 6:20 AM by Anil Kumar RSS

    Analyse customers in cohorts

      Hi all!

       

      I would like to organise my sales records in a table like the following (random numbers filled in).

       

      Year of first Purchase\Year of repeat purchase201020112012
      2010612271869657
      2011
      46299351
      2012

      7521

       

      So, I have organised in a pivot table the customers based on the first purchase year date and then counted their repeat purchases over the years to follow. How is this feasible to accomplish in qlikview given that the dimension used is Year?

       

      Thanx in advance!