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...