I am looking for a way to create a rolling 12 periods report. I would like for user to only enter the "TO" (aka Upper Limit) Year and Period as variable.
After user enters Upper Limit, the "FROM" (aka Lower Limit) should derived by offsetting the Upper Limit by subtracting 10 periods. This should then result in a report covering a rolling 12 periods, which even crosses into previous year if appropriate.
I cant find a way to offset the lower limit of a value range, based on the upper range. Any ideas?