7 Replies Latest reply: Mar 7, 2017 12:47 PM by Dave Melillo RSS

    Set Analysis to Show % Change Automatically

    Dave Melillo

      I have a pivot table (pictured below) with 1 dimension, OppCreateMonth and one measure:

       

      =sum({<[Upsell ARR (converted)]={">0"}>}[Upsell ARR (converted)])

       

      QV334.PNG

       

      Is there a way to have an expression that automatically calculates the percentage change between each cell as you move right? This would allow me to write ONE expression and then graph the percentage change between periods at any level.

       

      Thank you,

       

      - dave