Hi,

I'm trying to count the result of a MDX query. I have a calculated
member which I use in the following query:

select [Measures].[Calc Member Amount Group] on 0.
[Customers].[Customers].Members on 1
from [Sales]

The results of this query would be for each row the amount group of the
corresponding customer.
Over this result I would like to perform another query to Sum all the
ocurrences of the amount groups. grouped by amount group.

In T-SQL would be:

select Count([Amount Group])
from [Sales]
group by [Amount Group]

Can any one tell me how can I do this in MDX?

Tks.