9 Replies Latest reply: Mar 11, 2013 5:40 PM by 844487 RSS

    Add_months function on Month Column

      Hello guys,

      I have requirement where when user select Fiscal Year and then Month (MMM-YY) in prompt report should get last 13 months data. in report i have two columns Month and Count.

      Expected results are
      MAR-13 12
      FEB-13 15
      JAN-13 16
      MAR-12 20

      up to whatever the parameter has selected -13 months.

      Please let me know what should i do to get this kind of report.
      I am using OBIEE