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

    Pivot Table - Base 100 data

    Pierre Philippon



      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.