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.