Building a Revenue Recognition Schedule
I need to build a calendar type schedule of revenue recognition, based on the dates scheduled. This would hopefully be available for previous and definitely for future time frame. The end result is to be able to determine, per group, how much revenue needs to be recognized in the current/previous month, and what the revenue recognition will look like in the future. See attached sheet of what I am envisioning. Some months were cut out to show the range. For instance, ideally maintenance would have amounts covering 13 months.
I am struggling with the beast modes needed to create the month view.