Dette MDX eksempel viser hvordan man kan beregne den aktuelle pct af total salget, og pct af total salget for niveauet over det aktuelle.
WITH MEMBER [Measures].[Pct of total] AS ' SUM( {[Product].CurrentMember}, [Measures].[Unit Sales]) / SUM( {[Product].DefaultMember}, [Measures].[Unit Sales])', FORMAT_STRING='#0.00%' MEMBER [Measures].[Pct of parent total] AS ' IIF( [Product].Parent NULL, SUM( {[Product].CurrentMember}, [Measures].[Unit Sales]) / SUM( {[Product].Parent.Children}, [Measures].[Unit Sales]), 1)', FORMAT_STRING='#0.00%' SELECT { [Measures].[Unit Sales], [Measures].[Pct of Total], [Measures].[Pct of parent total] } ON COLUMNS, NON EMPTY Order( DESCENDANTS( [Product] ), [Measures].[Pct of total], DESC ) ON ROWS FROM [Sales]