2 Replies Latest reply: Oct 17, 2011 11:28 AM by Lawrence Chapman RSS

    Refferencing the Previous Period with a Cyclic Dimension Group

      Hi All,

      In the attached example I have a Pivot table with two cyclic group dimension. One for Calendar fields and another for another other relevant dimensions.

       

      Pivot.bmp

       

      What I would like to do is add second expression that will calculate the % increase from the previous period , but still allow the user to change the calendar dimension from Month to Quarter to year to week etc. is there a way I can generically refer to to the previous period in a cyclic group dimension?

       

      Many thanks

       

       

      Lawrence