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)

       

       

      Thanks,

      AS