5 Replies Latest reply: Feb 6, 2012 4:32 AM by Stefan Wühl RSS

    How can I calculate the number of dimension 2 divide by the number of dimension 1

      Hello,

       

      I have a dynamic array with 2 dimensions (fiscal year and period). I want to calculate the number of user per period and get the pourcentage by the number of user for the fiscal year.

      Here is the result i would like to have :

                                              PERIOD

      FY          Total     1week     1month     1quarter     1year

      2012          100     10%          30%          50%          20%

      2011          150     5%            25%          70%          0%

      2010          125     20%          20%          50%          10%  

       

      How should I write the expression?

       

      Thanks