Skip to Content
0
Former Member
Jul 19, 2005 at 11:25 PM

BEX Report on Fiscal Report Year

8 Views

Hello Experts,

I have Report Year and Fiscal Period/Year as a characteristics. In one of my BEX reports, I have to use Report Year as moving Year defined by user when they run query. For example,

In selection criteria, user may enter Fiscal Report Year like 006/2001. So, query will collect data for each Fiscal Report Year under column FRY 2002 (starting from 006/2001 to 005/2002); under column 2003 (006/2002 to 005/2003);.........;under column 2005 (006/2004 to 005/2005).

Again, if user enters 002/2001 as a Fiscal Report Year then query will provide data like under coulmn FRY 2002 (starting from 002/2001 to 001/2002); under column 2003 (002/2002 to 001/2003);.........;under column 2005 (002/2004 to 001/2005).

It will appear like:

FRY 2002 FRY 2003 FRY 2004 FRY 2005

1 Month 100 50 200 100

2 Months 10050 5050 200100 100200

3 Months 10050200 5050100 20010050 100200100

.

.

.

.

and so on.

Total of 12 Months starts from the period that user will give and doesn't follow Jan to Dec.

Can some one please help me how can I define query with this type of moving 12 months total for given char.? Please let me know if you need more information. I will appreciate your help. Thanks.

Regards,

Kate