Hi All
I am creating a report with the following format.
<chars..> , 0Calyear , Jan, Feb, ...., Dec, YTD
ABC......., 2004, 570, 240,....,300, 1500
ABC......., 2005, 200, 300, ...., 900, 2000
DEF......., 2004, 150, 200,.....,300, 2200
.....
.....
Results ........................
I have made the Jan, Feb, march as selections with hardcoded months and the YTD is based upon a user exit variable which restricts the selection from Jan to currnet month.
Nows the user wants to have the range of month in the selection screen wherein he should be able to specify the range of the months like from Jan to Aug.
Now my problem is when I try to make the months dynamic by placing Calmonth in the columns and restricting by a variable I am not able to calculate YTD there. Can you please suggest how to include the YTD along with the months as selection. Please help
Thanks
Randy