 复制SELECT {([Measures].[Reseller Sales Amount])} ON COLUMNS,应用 TopCount( {[Product].[Subcategory].[Subcategory].Members}, 5, ([Measures].[Reseller Sales Amount]) ) ON ROWS FROM [Step-by-Step]; /* Reseller Sales Amount Road Bikes $29,358,206.96 Mountain Bikes $26,492,684.38 Touring Bikes $10,451,490.22 Mountain Frames $4,713,672.15 Road Frames $3,849,853.34 */ 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17. |