I have the following MDX statement:
WITH SET [Data] AS
'{[Measures].[Internet Order Count], [Measures].[Internet Total Product
Cost],
[Measures].[Internet Sales Amount], [Measures].[Internet Average Unit Price],
[Measures].[Internet Gross Profit Margin]}'
SELECT
[Data] ON COLUMNS,
[CUSTOMER Geography].[Country].AllMembers ON ROWS
FROM [Adventure Works]
It returns the data correctly, however, I want to add the grand totals for
each column, like it does when you use the browser in BIDS.
Any help is appreciated and thanks in advance
WITH SET [Data] AS '{
[Measures].[Internet Order Count],
[Measures].[Internet Total Product Cost],
[Measures].[Internet Sales Amount],
[Measures].[Internet Average Unit Price],
[Measures].[Internet Gross Profit Margin]
}'
SELECT
[Data]
ON COLUMNS,
{
[Customer].[Customer Geography].[Country].AllMembers,
[Customer].[Customer Geography].[All Customers]
}
ON ROWS
FROM [Adventure Works]
"Toby" <To...@discussions.microsoft.com> wrote in message
news:C4B159DD-BEA9-40EF...@microsoft.com...