Thank you for this post.

I'm trying to add the percentage. This is what I have:

WITH

SET [TCat] AS TopCount([Product].[Subcategory].[Subcategory],10,[Measures].[Sales Amount])

MEMBER [Product].[Subcategory].[Other] AS Aggregate([Product].[Subcategory].[Subcategory] - TCat)

MEMBER [Measures].[Percent] AS [Measures].[Sales Amount] / ([Measures].[Sales Amount],[Product].[Subcategory].CurrentMember.Parent),format_string='0.00%'

SELECT{ [Measures].[Sales Amount], [Measures].[Percent] } ON COLUMNS,

TCat + [Other] ON ROWS

FROM[Adventure Works]

It works fine, except for the [other].

Can somebody help here?

Thanks a lot,

lab