Monthwise Amount expressions according to fin year
I have 1 selections, End Date.
I want a report in which i want to show month wise expressions starting from the first fin month i.e apr till mar.(no month dimension)
So there will be 12 expressions in this report.
when i select end date as 30 apr 2011 then it should show data only in apr expression.
when i select 15 jun then ,data will be shown in apr column from 1-04-2011 till 30 - 05-2011 ,in may column from 1-05-2011 till 31-05-2011 and in jun column from 1-6-2011 till 14-06-2011 ,rest all month expr will have 0 value.
In short ,the 12 columns will be filled with amount according to the End date.