Hallo everyone,
I have 3 data elements:
1. Top = topCount ([DataSet];?Top x?;NumExp)
2. SetForRest = except([DataSet];[Top])
3. Rest = member (total(currentMeasure within set [SetForRest]);'Rest';'Rest';[SchemaName].[DimensionName].[DimensionHierarchy])
Goal:
Top + Rest
So, my goal is to summarize Top and Rest. My first move to do so looks like this:
total(currentMeasure within set[Top])
This will summarize the value from all the Top members
My question:
How can I additionally take Rest into it? I tried this, but it didn't work:
total(currentMeasure within set[[Top],[Rest]])
Thank you..
Regards,
Ratna
It looks like Top + Rest = DataSet so why don't you just calculate total( currentMeasure within set [DataSet] ) ?
I agree with Greg, you shouldn't have to try and total the two sets when you already have the set [DataSet].
However, assuming you didn't, the way to do that calculation would be:
total(currentMeasure within set( set([Top],[Rest])))
It looks strange, but after you say you want to aggregate the current measure with a set, you need to provide a valid set, in this case defined by another set command.
Hallo Greg and tjohnson3050,
thank you for the hints, it worked with good performance. I learnt someting -> "sometimes you have to think simple" :P
Regards,
ratna ;)