0 Replies Latest reply: Sep 17, 2012 5:07 AM by JATIN KOLHE RSS

    Monthwise Amount expressions according to fin year

    JATIN KOLHE

      Dear All,

       

      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.