| Hi there,
When you run the script
With member measures.x as sum([Product].[Product Categories].[Product].members,
IIF([Measures].[Internet Sales Amount] > 1000,1,Null)),format_string='#;#;#;0'
select [Date].[Calendar].[Month].members on 0,
[Customer].[Customer Geography].[City].members on 1
from [Adventure Works]
Where Measures.x
One like that
one for Calendar year
one for Calendar year and Geography State
You will get 3 different results set?
Why is that
Thanks,
Oded Dror
|
|