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.
Is there a way to do some kind of incremental LOOKUP? So each row it would look up an additional column.
Attached image below.
You are looking to populate the top with the number of months passed between customer join and date? Can you just use DATEDIFF('month',[Customer Date],[Date]) and land that in your columns as a discrete set of values?