The query below removes the calculated members ([Measures].[Gross Profit] and [Measures].[Average Unit Price]) from the columns axis.
|
|
SELECT STRIPCALCULATEDMEMBERS({[Measures].[Sales Amount], [Measures].[Gross Profit], [Measures].[Average Unit Price]}) ON COLUMNS
FROM [Adventure Works]
|
|
|
|
|
|
|