8 Replies Latest reply: Mar 6, 2012 11:31 AM by j i RSS

    Calculating Percentage Change

      Hi Experts,

       

      I have 6 month end data for sales. For 6 months i have defined 6 variables.I am trying to calculate month on month sales variance in the expression of a chart.

       

      screen shot.JPG

       

      I want to calculate and show the percentage change in the expression as shown above.

      Please note that my chart will 2 columns:

      1. The selected month

      2. Variance between the selected month and its previous month, in percentage.

       

       

      Hopefully I am able to make you understand what exactly I am looking for.

       

      Thanks in advance

       

      Paul..