complex calculation

[djallelsadki]

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

[#2]

Hello . Take This.

Bye Marco

[djallelsadki]

Hi,

Thank you

i still have a problem

the final result for january and february is null

any idea ?

Thanks

D.S

[#4]

Becuse you don't have the record from previous data

exaple

take feb11

result( FEB11) = sum(field1) feb11) / ( sum(field2 feb11) + sum(field2 gen11) + sum (field2 dic2010 ) )

You don' t have dic2010

do you understand?

Marco

[djallelsadki]

For your example :

the data of december 2010 exists

the problem is for all the months of January and February

01/2010, 02/2010

01/2011, 02/2011

01/2012 ,02/2012

the "above" function do not get the data from the previous period

with regards

D.S

[#6 · Accepted solution]

take this

[djallelsadki]

Thank you

D.S