I have a question. I have to develop a Report where the requirement is 12 colums starting from current period going back 12 months this could go back a year also.
The report should have 12 colums always.
You can try to create a structure with your Period char (0FISCPER) in the selections. Add a variable to the first selection (not sure if there is a std var for returning the current period, else you can create a user entry var, or may be code on for yourself). In the remaining 12 selections, use the same variable to restrict 0FISCPER, but use variable offsets...going like -1, -2...-11 for the 12th column.
You can also do restricted key figures, but if you create just a Period structure, you can reuse it in a numebr of reports...depends on your requirement.
Hope this helps...