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 purchase||2010||2011||2012|
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!