8 Replies Latest reply: Sep 18, 2015 2:25 AM by Kumar Pramod RSS

    Last 12 months data

    Kumar Pramod

      Hi all,

       

      I am displaying the data according to months from 2012 but now i need only last 12 months excluding the present month.

       

      In data load i am using the below month function:

       

      MonthName(date_created) as Month_Year.

       

      In dimension i am using : Month_Year.

      In Measures : count({<Month_year={">$(=date(max(Month_year)-13))<=$(=date(max(Month_year)-1))"}>}user_signed)

       

      This is not working anyone please help on this.

       

      Regards,

      Pramod