Returns a set of members ending either at the specified member or at the current member in the time dimension.
LastPeriods ( numeric value expression [, member ] )
numeric value expression | The number of members to return. If negative, member is treated as the starting point. |
member | Optional. A member expression. |
Lastperiods(3, Apr)
returns the set {Feb, Mar, Apr}
.
Lastperiods(-3, Apr)
returns the set {Apr, May, Jun}
.
Lastperiods(1, Apr)
returns a set of one member: {Apr}
.
Lastperiods(0, Apr)
returns an empty set.
Lastperiods(5, Apr)
returns the set {Jan, Feb, Mar, Apr}
.
Note that the output set has only four members.
The following query:
WITH MEMBER [Measures].[Rolling Sales] AS 'Avg ( LastPeriods (3, [Year].Currentmember ), [Measures].[Sales] )' SELECT {[Measures].[Sales], [Measures].[Rolling Sales]} ON COLUMNS, Descendants ([Year].[Qtr2]) ON ROWS FROM Sample.Basic WHERE [Product].[Root Beer]
returns the grid:
Sales | Rolling Sales | |
---|---|---|
Qtr2 | 27401 | 27014 |
Apr | 8969 | 8960 |
May | 9071 | 8997 |
Jun | 9361 | 9133.667 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |