Cumulative sum for current financial year to till-date & for previous yr.
Could anyone please suggest the procedure to be followed in reporting, to calculate the cumulative sum of 2 fields for different projects
1. Current financial year (from 01.04.2011 to today) and
2. Previous financial year (from 01.04.2010 to 31.03.2011)
Report output should be like this :
Projects names in ROWS
2 fields data for entire Previous fiscal year & Current fiscal year to till date in COLUMNS