4 Replies Latest reply: Jun 23, 2013 9:11 AM by Selvakumar S RSS

    Previous Year Same month Set Analysis

      Hi All,

       

       

      I want to take the sum of previous year same month based on my month selection. For that i wrote like this below,

       

       

       

      Sum

       

      ( {<Year=,
      Month =,
      SALES_DATE = {"$(=date(MonthName(AddMonths((max(SALES_DATE)), -12)),'YYYYMM')"}
      >} Sales Cost

       

       

      But its not working. What im doing wrong here..  My Sales date format is YYYYMM

       

       

      Thanks,

      Selva