7 Replies Latest reply: Dec 8, 2015 2:23 AM by kushal chawda RSS

    Last 12 months expression help!

    Amit Saini

      Hi Folks,


      We are having one of our application in which


      Dimension: = Month ([GSE Overall.GSEoverallmonth]) & '-' & Year ([GSE Overall.GSEoverallmonth])


      Expression: [GSE Overall.ppm]


      Below is the result table , now here we want one column to show last 12 months ppm rate.


      Please suggest how to do it.




      Actually we are not using any calendar for this Dashboard, otherwise I could have done something similar:


      Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1),  'MMM-YY'))"} >} Sales)