I have a measure that I want to display across all children of a particular level. No problem there.
However, I want to treat 8 particular children as individuals, but all others as an entity.
I started my MDX by declaring a set that is all children of the level, except those 8 particular children I want named expicitly.
What I was thinking of was an alias, as I know it in SQL.
Can I turn my Set into such an alias, so that I see the result for all but the eight as one column?
However, I want to treat 8 particular children as individuals, but all others as an entity.
I started my MDX by declaring a set that is all children of the level, except those 8 particular children I want named expicitly.
What I was thinking of was an alias, as I know it in SQL.
Can I turn my Set into such an alias, so that I see the result for all but the eight as one column?