Web Listing 3: Workaround 3 WITH MEMBER [Measures].[Sales in 2003] AS ([Measures].[Internet Sales Amount], [Date].[Calendar Year].&[2003]) MEMBER [Measures].[Sales in 2004] AS ([Measures].[Internet Sales Amount], [Date].[Calendar Year].&[2004]) MEMBER [Measures].[Profit in 2003] AS ([Measures].[Internet Gross Profit], [Date].[Calendar Year].&[2003]) SELECT {[Measures].[Sales in 2003], [Measures].[Sales in 2004], [Measures].[Profit in 2003]} ON COLUMNS, [Product].[Category].MEMBERS ON 1 FROM [Adventure Works]