Sum Children at different Levels -
01-03-2006
, 01:27 PM
Hi
I have a Answer dimension with following levels
Field -- Exercise
Value -- 1
member prop - Description (Caption) -- 00 to 15 minutes
Now I want to do this
(Pseudo MDX code)
Select [Exercise].[00 to 15 minutes]+[Swim].[Less than 15 minutes] on
rows,
[Measures].[Encounter] on columns
from AnswerCube
Exercise and Swim are members of Field level.
thanks
Milind |