sum of sales of the last 12 periods june 1997 / june 1998 in mdx

#1

Hi,

What is the mdx code to show a sum of sales in foodmart 2000 of the
last 12 periods starting june 1997 / june 1998 while june 1998 is
choosen as reporting date ?

With this formula you see only the months this year:
SUM(YTD([Time]),[Measures].[Sales])

Regards, Marco

#2

try the lastperiods function
sum(lastperiods(12), measures.sales)

"Marco" <olap (AT) gmsbv (DOT) nl> wrote

Quote:

Hi,

What is the mdx code to show a sum of sales in foodmart 2000 of the
last 12 periods starting june 1997 / june 1998 while june 1998 is
choosen as reporting date ?

With this formula you see only the months this year:
SUM(YTD([Time]),[Measures].[Sales])

Regards, Marco

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

sum of sales of the last 12 periods june 1997 / june 1998 in mdx

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

sum of sales of the last 12 periods june 1997 / june 1998 in mdx - 12-27-2005 , 08:05 AM

Re: sum of sales of the last 12 periods june 1997 / june 1998 in mdx - 12-27-2005 , 08:13 AM