Rolling Average

#1

I have a cube that I would like to be able to report a
rolling 12 month average. I assume this can be
accomplished through a calculated measure. Any help would
be greatly appreciated.

#2

John, something like this:

Avg(LastPeriods(12, Time.CurrentMember), Measures.[MyMeasure])

tom @ the domain below
www.tomchester.net

"John Ammann" <jammann (AT) jakelinc (DOT) com> wrote

Quote:

I have a cube that I would like to be able to report a
rolling 12 month average. I assume this can be
accomplished through a calculated measure. Any help would
be greatly appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Rolling Average

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Rolling Average - 11-03-2003 , 08:47 PM

Re: Rolling Average - 11-04-2003 , 12:09 AM