2 Replies Latest reply: Apr 25, 2010 7:32 AM by gino bockaert RSS

    Calculations in rows and columns of a pivot table

    gino bockaert

       

      In a pivot table i'm not able to construct a very basic financial report which makes calculations in rows

      (expression calculations eg. Sales/kg) & calculations in columns (dimension calculations eg. growth 2009 > 2010).

      Example report :

      2010 2009 Growth%

      volume(Kg)

      sales

      sales/Kg

       

      As far as I know calculations are only supported in the Expression tab. Even with set analysis this doesn't seem

      possible.

       

      Any idea ??

       

       

      Gino Bockaert.