Hi,
I have developed first report successfully with the below layout (Fiscal period with single value as mandatory):
Actuals YTD_Actuals Budget YTD_Budget
Char 1 Char 2
Now the user is asking for the similar layout as (Fiscal period with Interval value as mandatory):
Actuals YTD_Budget
Char 1 Char 2
If the user runs FISCPER from 001/2012 - 004/2012 and the results should show for actuals as
Actuals (001/2012) Actuals (002/2012) Actuals (003/2012) Actuals (004/2012) YTD_Budget (from 001/2012 to 004/2012)
Char 1 Char 2
Where as YTD Budget should pick the highest FISCPER from the selection and display YTD Budget calculation from 001/2012 to 004/2012 into one column.
Can this task be done in one report? Please provide your expert opinions.
Thanks,
Panadu.