-
MDX - TopCount
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
-
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]
-
Thanks for posting the solution ...
Nice and efficient ...
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|