最好的结果+剩余的结果，与％

Question

我试图创建一个MDX查询来显示前10个结果+所有其他结果的集合，其中包括10个第一部分。到现在为止还挺好。但我也想显示每个结果的百分比。这是我迄今为止所拥有的。你可以试试Adventure Works：

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] 

一切工作正常，除了[Other]的％。 任何人都可以帮我解决这个最后的问题吗？

Answer 1

成员[Product]。[子类别] .CurrentMember.Parent不是[Other]成员的父项。

尝试这种解决方案：

WITH 
MEMBER [Product].[Subcategory].[Parent] AS Aggregate([Product].[Subcategory].[Subcategory]) 
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].[Parent]),format_string='0.00%' 

SELECT { [Measures].[Sales Amount], [Measures].[Percent] } ON COLUMNS, 
TCat + [Other] ON ROWS 
FROM [Adventure Works]