sum in mdx statement

[craig322]

I am trying to write an mdx statement that will show me the sum of each group's (a dimension level) sales amount across all the years of the cube.

I thought the following would work but I am only getting the current year.

SELECT {[Measures].[Sales]} on columns,
[Organization].[Group Name].Members on rows
FROM [Daily Sales]

If I were writing the SQL, it would be

SELECT group_name, sum(sales)
FROM my_table
GROUP BY group_name

Any help would be greatly appreciated as I am new to MDX

TIA

 

[justins57]

craig,

You need to do a crossjoin().

Select CROSSJOIN([Date].[Year].Members,{[Measures].[Sales]} on COLUMNS,
[Organization].[Group Name].Members on ROWS
FROM [Daily Sales]

hope this helps.

Justin