2 Replies Latest reply: Mar 19, 2013 9:27 PM by Rui Correia RSS

    Dinamic Growth Calculation

    Rui Correia

      Hi all!

       

      I am trying to present a Growth Calculation (Current Value / Previous Value) in a Pivot Table with two dimensions, Product and Period.

      I have different periods (Month, Quarter, YTD, MAT, ...) and Users can select the Period Type and Period (Month / Range of Months for example) and the Table changes accordingly.

      My data is for a 5 year period so I wanted the Table to dinamically calculate the Growth for all products and the 60 months (Month Selected) automatically.

       

      The problem is because Period is in the dimension, I don't seem to be able to calculate the SUM of the previous period.

       

      I attach a simple example just with Current Value and Previous Value and the Previous does not work.

       

      Thanks in advance for any help you might give me.