SELECT { ([Dim Product].[English Product Category Name].Members, [Dim Customer].[Gender].[M]) // , // ([Dim Product].[English Product Category Name].[Bikes], // [Dim Customer].[Gender].[F]) } ON COLUMNS, --CROSSJOIN ( { [Measures].Members } * { [Dim Product].[English Product Category Name].Members } // [Measures].Members // , // [Measures].[Sales Amount]--, --[Measures].[Order Quantity - Fact Reseller Sales], --[Measures].[Sales Amount - Fact Reseller Sales] ) ON ROWS FROM [Kostka sprzedaży] //WHERE //( // [Dim Product].[English Product Category Name].[Bikes] //); SELECT { ([Dim Product].[English Product Category Name].Members, [Dim Customer].[Gender].[M]) // , // ([Dim Product].[English Product Category Name].[Bikes], // [Dim Customer].[Gender].[F]) } ON COLUMNS, --CROSSJOIN ( { [Measures].Members } * { [Dim Product].[English Product Category Name].Members } ) ON ROWS FROM [Kostka sprzedaży] //WHERE //( // [Dim Product].[English Product Category Name].[Bikes] //);