Hello every one ,

i would like to have a query where the YTD is replace by the last 12 month.

WITH MEMBER [TIME].[1998 YTD] AS 'SUM(YTD(ClosingPeriod(Month,
[Time].[1998])))'
MEMBER [TIME].[1997 YTD] AS
'SUM(YTD(ParallelPeriod(Year,1,ClosingPeriod(Month , [Time].[1998]))))'

SELECT {[TIME].[1998 YTD],[TIME].[1997 YTD]} ON ROWS, Measures.members on
columns from sales

I was thinking about periodtodate but it's not what I need


Thanks

Best Regards,

Patrice

Simply use
(iif([Time].CurrentMember.Level.Ordinal=[Time].[Month].Ordinal,Avg(LastPeriods(12,Time.currentMember),Co alesceempty(([Measures].[Sales]),0)),Null))


will give you last12month's sales average


"Patrice Lamarche" <Patrice_lamarche (AT) gco (DOT) ca.nospam> wrote

Thanks alot... it was lastperiod i was searching


Best Regards,

Patrice
"Prasanna" <tawargerip (AT) hotmail (DOT) com> wrote

ds(12,Time.currentMember),Coalesceempty(([Measures].[Sales]),0)),Null))