I have created a tabular report. Some of the columns I have are titled "AdjustedHistory1", "AdjustedHistory2" and so on. I also have columns titled "AdjustedForecast1", "AdjustedForecast2", and so on. I want a column to be able to retrieve the current date and thus display the information "July" (i.e. the current month). Next, I want "AdjustedHistory1" to be June, "Adjusted History2" to be May, and so on. Then I want "AdjustedForecast1" to be August, "AdjustedForecast2" to be September, and so on. The trick is, I need these fields to auto-update; meaning so that when the current month is August, "AdjustedHistory1" is July, "AdjustedHistory2" is June, "AdjustedForecast1" is September, and "AdjustedForecast2" is October.
How do I go about doing this