COMPARE WITH MAX PREVIOUS 3 YEARS

[inigoelv]

Hello:

I am interested to know THE EXPRESSION to calcul the Maximun value of the last three years.

I have the folowing table:

Product	2000	2001	2002	2003	2004	2006
A	200	900	150	400	500	300
B	23	567	456	378	234	789

I would like to know the % of every year comparing the maximun value of the last 3 years.

In the example:

2002:

A=150/900

B=456/567

2006:

A=300/500

B=789/456

Thanks in advance

[#2 · Accepted solution]

You have to use the following expression: Sum(Value) / RangeMax(Before(Sum(Value), 1, 3))

Attached you have an example.

JG