1 Reply Latest reply on Aug 18, 2017 2:57 PM by Justin Larson

    Incremental Lookup

    Andrew Lin

      So in my data I have a field for Customer Join Date. I created a crosstab view to show retention rate % of each cohort per month, but I want to chance to top column to equal Time Period instead of months. So it would look like this.

       

      Month Joined0123

      July 2013

      100%92.1%85.5%80.6%
      August 2013

      100%

      91.1%86.6%82.1%
      September 2013100%94.8%89.5%87.2%
      October 2013100%91.2%87.6%83.9%

       

      Is there a way to do some kind of incremental LOOKUP? So each row it would look up an additional column.

       

       

       

       

      Attached image below.