function that can be used in a member formula

[0405V]

Do we have a function that can be used in a member formula that will calculate the average of the last 3 periods.

Example: If my current forecast month is June, I want to calculate the average for the months of May, April, March for which I have actuals for a given account. 

Thank you.

[Omkareshwar]

You can use View dimension for this.

Thanks, Omkareshwar

Archetype Consulting