1 Reply Latest reply: Jan 12, 2012 12:17 PM by Fernando Suzuki RSS

    Pivot Table - Base 100 data

      Hello.

       

      I have a pivot table with 2 dimensions. First one is Date, second one is Product.
      I would like to show the evolution of Products' Prices starting from 100 (rebased data).

       

      Attached is the table that I would like to get. I have been trying to achieve this using First() function, but no luck...

       

      Many thanks for your help.