|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Yesterday @ 8:01 PM
Points: 408,
Visits: 688
|
|
This works on the adventure works cube. Post your query
WITH Member [Measures].[Something Made Up] as ( [Measures].[Internet Order Count] )
Select { [Measures].[Internet Order Count] ,[Measures].[Something Made Up] } On Columns, ( [Sales Territory].[Sales Territory Country].&[Canada] ) on rows FROM [Adventure Works]
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:26 AM
Points: 40,
Visits: 72
|
|
i will try it. thanks a bunch
|
|
|
|