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

    Last 12 months data

      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.