MDX在EXCEL透视表的写法

在透视表里,使用MDX ,要注意写法.

下面提供几个示例,

Median( ( [DimDate].[CalendarYear].CurrentMember * [DimDate].[EnglishMonthName].[All].Children ) , CoalesceEmpty ( [Measures].[Sum of SalesAmount] , 0 ) )

Excel!Quartile( SetToArray ( ( [DimDate].[CalendarYear].CurrentMember * [DimDate].[EnglishMonthName].[All].Children ) , CoalesceEmpty ( [Measures].[Sum of SalesAmount] , 0 ) ) ,1)

CUBEVALUE("PowerPivot Data",CUBESET("PowerPivot Data","Head([DimDate].[CalendarYear].[All].Children)"),"[Measures].[Quartile]")

Excel!IRR( SetToArray ( [Table3].[b].[All].Children, [Measures].[Sum of a] ) )

如果掌握了, 非常有用,特别是用于透视表计算.