Skip to Content
0
Feb 15, 2010 at 02:46 PM

Bex query- Dynamic selection of next 4 periods according to Month drilldown

120 Views

Dear All.

I am working in BI 7.0.

I want to do a report which shows Begining inventories and Forecast. The report will be drill down by Year/month which filters Begining inventory. For Forecast, I would liek to see 5 months of forecast in 5 different colums, starting from the month of begining inventory.

As an example:

Month FORECAST1 FORECAST2 FORECAST3 FORECAST4 FORECAST5

01.2009 01.2009 02.2009 03.2009 04.2009 05.2009

02.2009 02.2009 03.2009 04.2009 05.2009 06.2009

03.2009 03.2009 04.2009 05.2009 06.2009 07.2009

04.2009 04.2009 05.2009 06.2009 07.2009 08.2009

The colums month is the drill down of Year/Month characterisitic. The values on forecast represent the selection of period for each column for the forecast data.

How could I build this? Is there any way to do this?

Thanks a lot and best regards,

Alfonso.