3 Replies Latest reply: Mar 22, 2017 3:04 PM by Sunny Talwar RSS

    Set analysis, 12 months prior with p() function

    Jurien Groot

      Hi,

       

      I have a table with the following column / measure:

      Sum({$<[Order Ship MonthID]= p(MonthID), [Order Create MonthID]= p(MonthID)   >}Orders)

       

      That is working perfect for what I want. Now I want to have the values from 12 months prior next to it.

      I tried something like:

       

      Sum({$<[Order Ship MonthID]= p($(MonthID)-12), [Order Create MonthID]= p($(MonthID)-12)  >}Orders)

       

      Is it possible to have a calculation for all values in p()? What would be the syntax?


      Thanks in advance!