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

    Set analysis, 12 months prior with p() function

    Jurien Groot



      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!