buggtb · April 9, 2015 13:30
diff --git a/gistfile1.txt b/gistfile1.txt
 WITH
 SET [~COLUMNS] AS
    {[Time].[Time].[1997]}
 SET [~ROWS] AS
    Order({[Employee].[Management Role].[Management Role].Members}, [Measures].[Avg Salary], BDESC)
 SELECT
 NON EMPTY CrossJoin([~COLUMNS], {[Measures].[Avg Salary]}) ON COLUMNS,
 NON EMPTY [~ROWS] ON ROWS
 FROM [HR]
	WITH
	SET [~COLUMNS] AS
	{[Time].[Time].[1997]}
	SET [~ROWS] AS
	Order({[Employee].[Management Role].[Management Role].Members}, [Measures].[Avg Salary], BDESC)
	SELECT
	NON EMPTY CrossJoin([~COLUMNS], {[Measures].[Avg Salary]}) ON COLUMNS,
	NON EMPTY [~ROWS] ON ROWS
	FROM [HR]
No results found