rolling 3 month average for past 6 months

[#1]

Hi

I need to calculate the rolling 3 month average for a key performance indicator.

1. In the expression, how do I select the current month and months -1, ... -6;

2. How do I calculate the rolling avg for these months.

Will appreciate

Fanie

[#2]

Fanie,

1 approach i know is with island table and if in expression:

[#3]

and 2'nd with intersection and set analysis

[Gysbert_Wassenaar]

This document may be of use: Calculating rolling n-period totals, averages or other aggregations

[#5]

Dankie Gysbert

[#6]

Thank you Dariusz

[#7]

Dariusz do you have an example of intersection and set analysis?

Fanie

[#8]

Examples are attached above....

Can't you see them?

[#9]

ohh, i'am sorry, no i can see, that i attached the same twice. give ma a moment

[#10]

I exchanged set example