6 Replies Latest reply: Jan 18, 2013 4:07 AM by Djallel SADKI RSS

    complex calculation

    Djallel SADKI

      Hello,

       

      I have a problem described as follows:

       

      a PivotTable I have 3 dimensions: country, year and month

      and tow expressions: sum (field1) and sum (field2)

       

      I want to get the following result

       

      result( Dec) = sum(field1) Dec) / ( sum(field2 dec) + sum(field2 Nov) + sum (field2 Oct ) )

       

      for example:

       

      pour December 2012 :

       

      result= 3185550 / ( 16158 + 17879 + 20188 ) = 58.74

       

      pour November 2012 :

       

      result= 3063960/ ( 17879+ 20188+ 16637) = 56

       

      see attached file

       

      If any one can help

       

      I am available for any questions

       

      with regards

       

      D.S