cancel
Showing results for 
Search instead for 
Did you mean: 

Rolling Period (From current period going back 1 year)

Former Member
0 Kudos

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.

Rajiv

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188975
Active Contributor
0 Kudos

Hi Rajiv,

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...

rajiv_deshpande
Explorer
0 Kudos

My input parameters are Current year and Current Period.

How do I handle the Year.

2005 2004

9,8,7,6,5,4,3,2,1 12,11,10

Rajiv

former_member188975
Active Contributor
0 Kudos

I guess the system takes that into account, so lets say you start with 09/2005 and with an offset of -11, it should go back 11 periods and get you 10/2004...

Also are you using Fiscal Period or Posting Period? If Fiscal Period, then why put a separate input for year??

Message was edited by: Bhanu Gupta