Thanks!
"Steven H" <steven...@ilg.com> wrote in message
news:OBjtmpsx...@TK2MSFTNGP03.phx.gbl...
Please try LASTPERIODS function in case you are using AS2005. Here is a
test script against Adventure Works DW in the samples.
with
member measures.x as
sum(
{
lastperiods(
7,
[Date].[Calendar].[Date].&[629]
)
}
,
[Measures].[Internet Sales Amount]
)
select
{
lastperiods(
7,
[Date].[Calendar].[Date].&[629]
)
} on 1
,
{
[Measures].[Internet Sales Amount]
,
measures.x
}
on 0
from
[Adventure Works]
HTH..
ZULFIQAR SYED
HTTP://ZULFIQAR.TYPEPAD.COM
"ZULFIQAR SYED" <dat...@gmail.com> wrote in message
news:1156381422.2...@75g2000cwc.googlegroups.com...