MDX - TopCount

[Silvana RB]

Necessary to demonstrate Sales for the 10 bigger Customers and the addition of the remain.
For example:
Customer 1 ..... 10000
Customer 2 ..... 11000
Customer 3 ..... 12000
Customer 4 ..... 13000
Customer 10 ..... 14000
Others ..... 9000

I obtained through of the TopCount to search the 10 greaters, but I do not have idea of as to obtain "Others" in my MDX.

Thanks,

Silvana

[MDX novice]

WITH
SET Top10Countries AS TopCount(EXCEPT([Customer].[Country-Region].Members,[Country-Region].[All Customers]),10,[Internet Sales-Sales Amount])
MEMBER[Customer].[Country-Region].[All Others] AS
Aggregate(Except(Except([Customer].[Country-Region].Members,Top10Countries),[Country-Region].[All Customers]))
SELECT
{[Internet Sales-Sales Amount]} ON 0,
{Top10Countries,[All Others]} ON 1
FROM [AdwentureWorks]

[Island1]

Nice and efficient ...

Bill