3 Replies Latest reply on Dec 10, 2017 11:30 AM by Shinichiro Murakami

    Change vs Previous Period

    lukasz.c

      Hi,

      I've got a problem with calculation for Change vs previous period. In attached workbook I've calculated count(id) for each month. Then in other column I need to calculate change vs previous period like: Change = (Current Period – Previous Period) / Previous Period

      So If I choose for example '2017-December' it should calculate Change =  (8 - 3) / 3 = 1.66 * 100 = 166%

      where 8 = value for 2017-December, 3 = value for 2017-November

       

      I've tried to find similar topic but all which I've found are related to table calculation but here I need to get previous month value on "fly"

      Can anyone help me on that?

      Thanks in advance