how to calculate an average of Prior 8 or 12 quarters on a rolling basis? has anyone done it? please share.

[OSAdmin]

Originally posted by Ashok Amresh

I am trying get rolling average of an Account (i.e. average of prior 8 OR 12 quarters  ). i am New to Onestream and really finding hard to find function etc. any help is appreciated.

[TonyToniTone]

I would suggest to try using a combination of the Time Dimension and the View Dimension to potentially resolve this.  Try using T#QuarterPrior8():V#QuarterAvg