Average top 4 above.

[spividori]

HI.

I need to compare each AñoMes with the top 4 of the last 12.

In the attached example:

1. Nov 13 = Oct 13, Sep 13, Apr 13 and Feb 13.

2. Oct 13 = Sep 13, Ago 13, Apr 13 and Feb 13.

3. Sep 13 = Ago 13, Apr 13, Feb 13 and Oct 12

and so on.

The calculation would be the month on the average of the top 4.

In example 1 = Nov 13 / average Oct 13, Sep Apr 13 and Feb 13.

Regards.

[#2]

please attach your excel sheet

[Gysbert_Wassenaar]

See attached qvw.

[#4]

Gysbert you solution is very good for small data sets.

Is there any way we can achive on the UI level ?

[spividori]

Hi Gysbert.

I need to do the calculation on the chart or if it could be done in the script, too, because in my application each month has several moves and they are related to customers.

I upload a excel for you to understand better. Thank you.

Regards.