Our enrollment team has asked to be able to see future comparisons for prior years. For example, how many more deposits did we have 7 days from now, last year, 2 years ago, etc.? Our DimHistoryOffset table is pretty much baseline so it includes comparisons for prior years, but only looking back from today's date (1 year prior, 1 year 7 days prior, etc.). Has anyone customized this to look forward from today's date? Is there a more obvious way to include/display this future comparative information that I'm not thinking of?
Eric Kieft, Roosevelt University