I have a requirement in the report that should have the below structure
Fiscal Year Actual Actual Actual Actual Actual Actual
YTD 2008 2009 2010 2011 2012
Char1 Char1 FiscalPer APR 2010 MAY2010 .... MAR2011
Fiscal Year and Fisc period are in column and Char1 and Char2 are in Rows of the report.
For a particular year alone, I need the actual amount splitted on fiscal year period and rest of the past and furture years the actual amount should be aggregated for the year.
Please let me know if have come across this scenario.
Edited by: ramesh kumar on Aug 10, 2010 5:52 AM