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

      August 2013


      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.