Search found 1 match
- Fri Jun 24, 2011 6:27 pm
- Forum: General
- Topic: Calculating subtotals using MDX
- Replies: 2
- Views: 15310
Re: Calculating subtotals using MDX
Use this: WITH MEMBER [Measures].[Unit Sales Subtotal Gender] AS ([Gender].CurrentMember, [Marital Status].CurrentMember.Parent, [Measures].[Unit Sales]) SELECT { { [Measures].[Unit Sales], [Measures].[Unit Sales Subtotal Gender]} } ON COLUMNS, { CrossJoin([Gender].[Gender].Members, [Marital Status]...