2 Replies Latest reply: Aug 9, 2012 6:16 AM by Matthew Crowther RSS

    How to create a Index Chart?

    Leandro Duarte

      Dear Colleagues,

       

      I'm trying to create a Index chart (base 100) .

       

      The expression "First" work fine for the pivot table but it is not working in the Line chart.

       

      Index table:

      Supplier201120122013201420152016
      a100101102103104105
      b1009998989796
      c100109118127136145


      Data table:

      Supplier201120122013201420152016
      a110111112113114115
      b120119118117116115
      c110120130140150160


      Basically the calculation I want to reproduce in the Line chart is the results of the current year divided by the first year.

       

      Could somebody help me to find the better expresion to create the Line chart? Any good solution would be welcome!

       

      Please find enclosed the example I'm using.

       

      Thanks in advance,

      Leandro Duarte