WITH MEMBER Product.Category.[ALL Products].[Total]
AS Product.Category.[All Products]
SELECT [Measures].[Reseller Sales Amount] ON COLUMNS,
NONEMPTY ([Date].[Calendar].[Month].MEMBERS *
[Product].[Category].[Category].ALLMEMBERS) ON ROWS
FROM [Adventure Works]
GO