Hi anybody can help in my following mdx qry?
Actually i want the sum of the sales placed for the last 3
days..the following qry:
'{Filter(newtime.Month.Members, NOT IsEmpty
((newtime.CurrentMember))).item(COUNT(Filter
(newTime.Month.Members,NOT IsEmpty(
newtime.CurrentMember ))) - 3}'
This is giving the unit sales for the last 3 Months..but i
want no..of sales for the last 3 Months..How...here is
some other example:
'{Filter([OE Date].[Std].[Date].Members, NOT IsEmpty([OE
Date].[Std].CurrentMember)).item(sum(COUNT(Filter( [OE
Date].[Std].[Date].Members,NOT IsEmpty([OE Date].
[Std].CurrentMember )))) - 3}'.
The abv qry returning the the value of order for the last
3 days...but i want the actual sum of orders placed in the
last 3 days...my orders meseaures is [measures].[so
qty]..how can i include the sum of the abv orders in the
qry???????????????

I'm confused trying to reconcide text with code. Here's a calc that sums the
last 3 periods (based on current member of time):

WITH MEMBER Measures.[Last3] AS
' Sum(LastPeriods(3, Time.CurrentMember), MyMeasure) '

public @ the domain below
www.tomchester.net

"delven" <anonymous (AT) discussions (DOT) microsoft.com> wrote