how would I expand this to work with other dimensions ?

want it to work with my time dimension as well.

COUNT(CROSSJOIN({[MEASURES].[Amount Dkkcurr]},

DESCENDANTS([T_No].CURRENTMEMBER,

[T_No].[T No])), EXCLUDEEMPTY)

You would need to add the time demension to the crossjoin that you are
counting. This will obvious slow down the calculation a bit.

COUNT(CROSSJOIN({[MEASURES].[Amount Dkkcurr]},
DESCENDANTS([T_No].CURRENTMEMBER,
[T_No].[T No])
DESCENDANTS([Time].CURRENTMEMBER,
[Time].[Month])
), EXCLUDEEMPTY)

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

thanx for the input. However I simply cannot seem to get it right

Tried this

COUNT(CROSSJOIN({[MEASURES].[Amount Dkkcurr]},

DESCENDANTS([T_No].CURRENTMEMBER,

[T_No].[T No]),DESCENDANTS([Due Date].CURRENTMEMBER,

[Due Date].members)) EXCLUDEEMPTY)

and this:

COUNT(CROSSJOIN({[MEASURES].[Amount Dkkcurr]},

DESCENDANTS([T_No].CURRENTMEMBER,

[T_No].[T No]),DESCENDANTS([Due Date].CURRENTMEMBER,

[Due Date].[Year])) EXCLUDEEMPTY)


"Darren Gosbell" <xxx (AT) xxx (DOT) com> wrote

I assume you are getting syntax errors?

I'm sorry about that, when I translated the calculation from using the
foodmart database to using your dimensions and measures I accidentally
left off a nested crossjoin.

The crossjoin() function can only take 2 sets as arguments so in order
to join more than 2 sets you need to crossjoin them.

see if this works, I have indented it to help line up the functions so
hopefully this one will work.

COUNT(
CROSSJOIN(
CROSSJOIN(
{[MEASURES].[Amount Dkkcurr]}
,DESCENDANTS([T_No].CURRENTMEMBER, [T_No].[T No])
)
, DESCENDANTS([Due Date].CURRENTMEMBER, [Due Date].[Year])
)
, EXCLUDEEMPTY)


--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell