Hi,
In my mdx query how to count the rows of dimension
table..ie if i want the no. of rows for [Measures].[Unit
sales] in the last 3 days...like below:
'{Filter(newtime.Day.Members, NOT IsEmpty
((newtime.CurrentMember))).item(COUNT(sum(Filter
(newTime.Day.Members,NOT IsEmpty(
newtime.CurrentMember ))) - 3)}'

The abv query is retriving sum but i want the count
only...how to retriev???

{myset}.Count

public @ the domain below
www.tomchester.net

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