1 Reply Latest reply on Jul 5, 2018 5:32 PM by patrick.byrne.0

    Yearly rolling figure of repaeat buy

    AJ.Yusuf

      Sorry Stuck again, keep bothering you sorry  I am trying to find a way to see if a customer for example brought in 2006 on a year scale when does he buy year 1, year2 , year3 ........etc

       

      I have posted the question in Yearly rolling figure of repaeat buy

       

       

      When do these customers return to buy again. How many years does it  take on average

      table

                  Yr 1  Yr2   Yr3   Yr4  Yr5    Yr6   yr7   yr8  yr9  yr10  yr11  yr12 (2018)

      2006   %       %

      2007

      .....

      2017

       

      thanks